Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Chronological Numbering
I have 30 spreadsheets in one file, and would like to chronologicaly number
them (have a certain cell display the number of that spreadsheet). I don't want to have to go to each spreadsheet and write a formula linking that spreadsheet to the previous one. Is there a way to have the cell in each spreadsheet look up the value of the same cell in the previous spreadsheet and add 1, without having to do this manually on every single one? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Chronological Numbering
Group the sheets (click first tab, hold SHIFT, click last tab)
In cell of first sheet enter =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255) Now that cell will show "Sheet1", "Sheet2", .... File must have been saved at least once before this works best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Chronological Numbering" m wrote in message ... I have 30 spreadsheets in one file, and would like to chronologicaly number them (have a certain cell display the number of that spreadsheet). I don't want to have to go to each spreadsheet and write a formula linking that spreadsheet to the previous one. Is there a way to have the cell in each spreadsheet look up the value of the same cell in the previous spreadsheet and add 1, without having to do this manually on every single one? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Chronological Numbering
Bernard,
This seems to work fine. The problem, however, is that I have the tabs of the spreadsheets labeled with different names. The values that I need in the cell are simply a chronnological 1-30... "Bernard Liengme" wrote: Group the sheets (click first tab, hold SHIFT, click last tab) In cell of first sheet enter =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255) Now that cell will show "Sheet1", "Sheet2", .... File must have been saved at least once before this works best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Chronological Numbering" m wrote in message ... I have 30 spreadsheets in one file, and would like to chronologicaly number them (have a certain cell display the number of that spreadsheet). I don't want to have to go to each spreadsheet and write a formula linking that spreadsheet to the previous one. Is there a way to have the cell in each spreadsheet look up the value of the same cell in the previous spreadsheet and add 1, without having to do this manually on every single one? Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Chronological Numbering
It will show the real sheet name, Bernard used Sheet1 etc as an example
using the built in sheet names -- Regards, Peo Sjoblom "Chronological Numbering" m wrote in message ... Bernard, This seems to work fine. The problem, however, is that I have the tabs of the spreadsheets labeled with different names. The values that I need in the cell are simply a chronnological 1-30... "Bernard Liengme" wrote: Group the sheets (click first tab, hold SHIFT, click last tab) In cell of first sheet enter =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255) Now that cell will show "Sheet1", "Sheet2", .... File must have been saved at least once before this works best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Chronological Numbering" m wrote in message ... I have 30 spreadsheets in one file, and would like to chronologicaly number them (have a certain cell display the number of that spreadsheet). I don't want to have to go to each spreadsheet and write a formula linking that spreadsheet to the previous one. Is there a way to have the cell in each spreadsheet look up the value of the same cell in the previous spreadsheet and add 1, without having to do this manually on every single one? Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Chronological Numbering
How about a macro?
Sub DoNumbering() Dim mySh As Worksheet For Each mySh In Worksheets mySh.Range("A1").Value = mySh.Index Next mySh End Sub HTH, Bernie MS Excel MVP "Chronological Numbering" m wrote in message ... I have 30 spreadsheets in one file, and would like to chronologicaly number them (have a certain cell display the number of that spreadsheet). I don't want to have to go to each spreadsheet and write a formula linking that spreadsheet to the previous one. Is there a way to have the cell in each spreadsheet look up the value of the same cell in the previous spreadsheet and add 1, without having to do this manually on every single one? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I calculate chronological age in excel | Excel Discussion (Misc queries) | |||
How to share a workbook when entries are chronological? | Excel Discussion (Misc queries) | |||
PO with sequential numbering with start / end numbering | Excel Discussion (Misc queries) | |||
Ability to arrange tabs in a worksheet in chronological order | Excel Worksheet Functions | |||
Numbering | Excel Worksheet Functions |