sequential numbering across multiple worksheets
 

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?

sequential numbering across multiple worksheets
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"carrera0000" wrote in message
...
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?

sequential numbering across multiple worksheets
 

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

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"carrera0000" wrote in message
...
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?

sequential numbering across multiple worksheets
 

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

On Mon, 16 Oct 2006 12:20:02 -0700, carrera0000
wrote:

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?