Question Locked

Need Excel Help linking worksheets with subsequent dates in same cell

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am creating a quarterly scheduling calendar for facility reservations,
consisting of two pages per day. The hard copy will live in a binder to
be referred to and written in daily.
Starting with Sept 1, I am wishing to automatically date each page, but I
can't seem to get the worksheets to link up past the first one.

3 replies

by locolobo

Each worksheet will have a cell assigned for the date. Say A1 just for arguments sake.

So in Sheet1!A1 I type in 9/1/2007.

In Sheet2!A1 I type in =Sheet1!A1+1

In Sheet3!A1 I type in =Sheet2!A1+1

and so on. This should work.

Maybe someone around here knows how to make a Macro that would save the typing?

by grayrobin

I tried that and it works fine, thank you for your speedy
reply...
However, I have 120 worksheets (18wks) of scheduling pages
to format, so I am hoping for a macro or more help to get
the job done.

This discussion is closed to new replies.