Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Reference Cell in Offset Formula | Excel Discussion (Misc queries) | |||
copy offset to cell | Excel Discussion (Misc queries) | |||
How to reference an offset from a cell? | Excel Worksheet Functions | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |