Use the Fill Handle Between Sheets in a workbook

[Mike]

Is there a way to choose one cell in each sheet of a workbook then type
the date in the first cell and make all the other sheets increase by one
day through the workbook? Ex. April 19,2004 on first sheet and April
30,2004 on the last sheet with each sheet in between being the correct
next date.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Nick Hodge]

Mike

Simply no... It could probably be done with a function and certainly with
code though

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[CLR]

You can set up your 30 sheets one time with links and formulas so that if
you just type the date in Sheet1, it will automatically increase by one day
for all the other sheets........

Put this in A1 of sheet2.........=Sheet1!A1+1 etc etc...........

Vaya con Dios,
Chuck, CABGx3

 

[Gord Dibben]

Mike

If you can go for a programming method, much easier.

Sub Date_Increment()
''increment a date in A1 across sheets
Dim myDate As Date
Dim iCtr As Long
myDate = DateSerial(2004, 4, 19)
For iCtr = 1 To Worksheets.Count
With Worksheets(iCtr).Range("A1")
.Value = myDate - 1 + iCtr
.numberformat = "mm/dd/yyyy"
End With
Next iCtr
End Sub

Gord Dibben Excel MVP