LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Repost: Copy and Offset cell reference

Hi Groupies:

I posted this a couple of days ago, but I missed the functions group, no
reply yet.

I was asked if this was possible and I can not think of how, hopefully,
somebody can help me.

On Sheet 2, I have the following data:

cell B2 =sheet1$N$14
cell B3 =sheet1$N$32

On sheet 3, I need to have

cell B2 =sheet1$N$15
cell B3 =sheet1$N$33

On sheet 4, I need to have

cell B2 =sheet1$N$16
cell B3 =sheet1$N$34

Basically, each sheet is a different month and the references need to
be offset each time. This needs to be done a number of times in this
and other workbooks.

Is there an efficient way to do this?

--
Thanks for taking the time!

CJ
---------------------------------------------------------
Know thyself, know thy limits....know thy newsgroups!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Reference Cell in Offset Formula MarkM Excel Discussion (Misc queries) 3 February 7th 07 05:11 PM
copy offset to cell Kev Excel Discussion (Misc queries) 6 December 31st 06 04:02 AM
How to reference an offset from a cell? poddys Excel Worksheet Functions 3 March 10th 06 08:24 PM
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. [email protected] Excel Worksheet Functions 2 December 11th 04 12:05 AM
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable [email protected] Excel Worksheet Functions 2 December 11th 04 12:00 AM


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"