on new month start want information from different cell

  • Thread starter Thread starter KMc
  • Start date Start date
K

KMc

Hi,
I have a workbook that has 3 worksheets in it. On the
first worksheet it is mainly a snapshot of the other
information but only for the current month.
What I want it to do is say in February we used the
information from C23 on the 2nd worksheet - now when March
starts I want it to pull the information from D23 and so
on. Can that be done? The second page of the worksheet
will be updated at least weekly.

thank you in advance,
Kathy
 
Hi
try the following (if B23 stores your January info):
=OFFSET('sheet2'!$B$23,MONTH(TODAY())-1)
 
Maybe I didn't explain very well (not a first for me...)

But here is what I currently have - in cell A1 ia today's
date that updates everytime the file is opened. Now in C3
I have this formula - =Modules!$G$19 - which gives me
the number that is from G19, when I open the file and the
date changes in A1 to 01-March-2004 I want the information
to be pulled from H19 on the Modules page.

Can this be done?
Thanks again,
Kathy
 
Hi Kathy
both formulas would work. Adapted to your specific design put this in
C3
=OFFSET('Modules'!$F$19,1,MONTH(A1)-1)
 
Thank you Frank - I don't know why this works but it did.
But my information is in G19.

I did change my date to check and it did update the right
information - so I am really confused!

If you can explain I'd love to hear it,
Kathy
 
Hi Kathy
quite simple:-)
(you may also check the Excel help for the OFFSET function)
OFFSET has the syntax:
OFFSET(cell_reference,rows,columns,[height],[width])
It will do the following:
- you enter your start cell/range as the first parameter.
- This is shifted by the number of rows entered in the second parameter
- and shifted by the number of columns in the third parameter)

I probalbly had an error in the formula. It should read:
=OFFSET('Modules'!$F$19,0,MONTH(A1)-1)

that is:
- 'Modules'!$F$19 is your starting point (the data for January)
- It is shifted by '0' rows (the second parameter). So it still is
$F$19
- It is shifted by the month number minus 1 columns. So for January it
is shifted by zero columns. For February by 1 column -> $G$19
 
Harald said:
C23, D23, ... is so weird a design that it had to be a real world
scenario. I thought. But no, C23 is a virtual representation, a pure
idea, an abstract, symbolizing the one and only Very Secret cell
address (drum roll) G19...
Click to expand...

lol
 
KMc said:
Maybe I didn't explain very well (not a first for me...)
Click to expand...

C23, D23, ... is so weird a design that it had to be a real world scenario. I thought.
But no, C23 is a virtual representation, a pure idea, an abstract, symbolizing the one and
only Very Secret cell address (drum roll) G19... Well, those things may complicate things
just a little if you require cut'n paste solutions.
Best wishes Harald
Followup to newsgroup only please.
 
Back
Top