Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search in Multiple Worksheets | Excel Discussion (Misc queries) | |||
SUMif or SUMproduct across multiple worksheets? | Excel Worksheet Functions | |||
Line chart from multiple worksheets | Charts and Charting in Excel | |||
Update multiple worksheets | Excel Discussion (Misc queries) | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |