sequential numbering across multiple worksheets

[Guest]

I have multiple worksheets in one excel file. I want to do sequentail
numbering across them.

The point I am trying to acheive is dating them. I have the date in top
right hand corner. In the first worksheet, there is 10-1-06 in cell A1. Then
in worksheet 2 in cell A1, I want 10-2-06 and so forth.

Is this possible?

 

[Bernard Liengme]

In A1 of Sheet2 =Sheet1!A1+1
In A1 of Sheet3 =Sheet2!A1+1
etc
You may need to format the cells as dates
If you have lots of sheets you will need a macro or an INDIRECT formula
Let us know!
best wishes

 

[Guest]

That actually helps me in the long run, but I would still have to enter that
formula in every worksheet.

 

[Gord Dibben]

Manually as Bernard suggests or use a macro.

Sub Date_Increment()
''increment a date in A1 across sheets
Dim myDate As Date
Dim iCtr As Long
myDate = DateSerial(2006, 10, 1)
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 MS Excel MVP