getting data from other pages

[johngio]

hi all,

I'm having a referencing dilemma. I've got 31 worksheets, named 1 to 31 (respectively). I have a main sheet with a different name. What I am trying to do is get data from one of the other pages using a date reference. E.g.

on sheet 2, cell A1, I have the text 'not completed'

On the main page, I have a date cell that reads 2/3/04 (cell B2)

I want to get that data in a new cell on the main page.

I tried this =('DAY(B2)'!A1) , but I get a REF# error. However, when I enter ='2'!A1 it works. Can someone please tell me how to fix my referencing. (By the way cell B2 does not reference another cell; it is the user input cell)

Thanks

 

[sbendbuckeye]

I'm not sure what you are asking, but to reference a cell on another sheet, you would use SheetName!A1. If your SheetName has embedded spaces then you would use 'Sheet Name'!A1. Hope this at least gets you started.

It also helps a lot if you can post a couple examples of what your input and output data should look like. Good LucK!

 

[johngio]

how do i attach an image ? I managed to convert my info to html, but I don't know how to attach it.

Thanks

 

[Fergus]

Hi John,

Try =INDIRECT(DAY(B2)&"!A1")

 

[johngio]

thanks

good to see - scotsman helping scotsman

 

[Fergus]

Aye, it's a pleasure.