| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sheet names used in formulas
I have a question about using sheet names in a formula. I would like the
sheet name to go up by one page for each row I put the formula in...(ie) 13A reads (="S40'!$W$5)... I need to have row 14 read (='S41'!$W$5) There are many many worksheets...260 in all that need this on them. Each worksheet is about 300 rows long. How can I do this without having to change the sheet name by hand??? Any help is greatly appreciated!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replacing just the sheet names within formulas | Excel Worksheet Functions | |||
| Locking Sheet names in formulas | Excel Worksheet Functions | |||
| How can I show sheet names in different colours | New Users to Excel | |||
| Listing of Sheet names | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Threaded Mode
