Here's my problem. One of my managers has a spreadsheet that has several
pages. Each page is for a different day of the week. (the first sheet is
Sunday, next is Monday, next Tues,.. etc)
She says when she puts the date on the first sheet, it's supposed to fill in
on all the other pages (1st page 11/26, next page 11/27, etc) but it doesn't.
(she says it used to, lol)
I know how to make a series on one page from cell to cell, either in rows or
columns, but have no idea how to do this on different pages.
Any suggestions? Is there a formula?
Thanks :)

Let's say the date is entered into cell A1 on sheet 'Sunday'. On sheet
'Monday' use this formula:

=Sunday!A1+1

Note: If the sheet name contains spaces, then it must be enclosed in
'single' quotes.

='Sun day'!A1+1

HTH,
Elkar

"Meenie" wrote:

Here's my problem. One of my managers has a spreadsheet that has several
pages. Each page is for a different day of the week. (the first sheet is
Sunday, next is Monday, next Tues,.. etc)
She says when she puts the date on the first sheet, it's supposed to fill in
on all the other pages (1st page 11/26, next page 11/27, etc) but it doesn't.
(she says it used to, lol)
I know how to make a series on one page from cell to cell, either in rows or
columns, but have no idea how to do this on different pages.
Any suggestions? Is there a formula?
Thanks :)

Hi Elkar,
That helps a lot! Thank you.
My husband also had a solution.
I'll use your sheet as an example
Go to the first sheet 'Sunday"
Type the starting date into cell A1
Go to the second sheet 'Monday'
In cell A1 type the equal sign =
then click on the tab for the first sheet, 'Sunday'
(this will open the first sheet)
click on cell A1 (it will get the squiggly lines showing it was copied)
then type +1
hit enter, and voila, the next days date will be in A1 on the second sheet.
:)

Thanks for your help, both methods work great :)
Meenie

"Elkar" wrote:

Let's say the date is entered into cell A1 on sheet 'Sunday'. On sheet
'Monday' use this formula:

=Sunday!A1+1

Note: If the sheet name contains spaces, then it must be enclosed in
'single' quotes.

='Sun day'!A1+1

HTH,
Elkar

"Meenie" wrote:

Here's my problem. One of my managers has a spreadsheet that has several
pages. Each page is for a different day of the week. (the first sheet is
Sunday, next is Monday, next Tues,.. etc)
She says when she puts the date on the first sheet, it's supposed to fill in
on all the other pages (1st page 11/26, next page 11/27, etc) but it doesn't.
(she says it used to, lol)
I know how to make a series on one page from cell to cell, either in rows or
columns, but have no idea how to do this on different pages.
Any suggestions? Is there a formula?
Thanks :)