3D formulas for Multiple sheet data entry question

[Drizz]

Hi all,

Im kinda new to this forum and actually stumbled upon it while doing a search on google. All the 3D formulas in Excel seem to be aimed at getting a summary from multiple work sheets. what I am looking for is a way to put a series of numbers or dates into each sheet of one work book.

Basically imagine you had a sheet for every day of the month and what i want to do is find an easy way of writing the date of each individual day in the same cell through the whole book. I have a screen shot of the document but cant seem to figure out how to put it on the post

 

[RoryA]

If you want the same data entered into the same cell on every sheet, then select all the sheets by clicking the first sheet tab, then Shift+clicking the last tab, then enter your data. When finished, Shift+Click the first tab to deselect the other sheets.

 

[Drizz]

If you want the same data entered into the same cell on every sheet, then select all the sheets by clicking the first sheet tab, then Shift+clicking the last tab, then enter your data. When finished, Shift+Click the first tab to deselect the other sheets.

Thank you for your reply Rorya but i want a series to go into each sheet. for example the first sheet is 1/1/2011 the second sheet will have 1/2/2011 and so on.

 

[Sektor]

=SUM(FirstSheet:LastSheet!A1)

This function will sum ALL A1 cells in sheets between FirstSheet and LastSheet (including them, of course).

 

[Drizz]

=SUM(FirstSheet:LastSheet!A1)

This function will sum ALL A1 cells in sheets between FirstSheet and LastSheet (including them, of course).

That would allow me to make a summary but thats not what im trying to do. What i have basically is 30 tabs and i want each tab to have the corresponding date in it for printing purposes. for eg

Dates(in cell A1) : 1/1/11 -- 1/2/11 -- 1/3/11 -- 1/4/11
Tabs (Names) : -----1-------- 2 ------- 3 ------- 4

That way when the month changes all I have to do is change the date in the first tab manually and the rest follow suit automatically. I could do this with putting a linking formula in each cell on each sheet but that would defeat the purpose.

 

[Drizz]

Either this post got bumped to the bottom of the forum or is it really not possible?

 

[RoryA]

You would have to use code; there's no built-in way other than the formulas you have already ruled out.