Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell Reference help required
Hello All, I have a problem with Cell reference between spreadsheets. Help would be highly appreciated. Here is what I need. I have 30 different spreadsheets in a workbook. Worksheet names (Aug01, Aug02, Aug 03….Aug30). All the sheets are similar. I need to refer the totals of the previous worksheet in the current one. Example: D5 of sheet Aug30 to D4 of sheet Aug29, ('Aug29'!D5) D5 of sheet Aug29 to D4 of sheet Aug28, ('Aug28'!D5) |
#2
|
|||
|
|||
It would be nice to have relative sheet referencing (in addition to
absolute) like we have with cell references. But in Excel (so far) all we have is absolute. You can do a Find/Replace after copying a sheet. Some people have developed UDFs to do a relative reference, if you want to go that way: http://snipurl.com/gqk1 -- Jim "Raja" wrote in message ... | | Hello All, | | I have a problem with Cell reference between spreadsheets. Help would | be highly appreciated. | | Here is what I need. | | I have 30 different spreadsheets in a workbook. Worksheet names (Aug01, | Aug02, Aug 03….Aug30). All the sheets are similar. I need to refer the | totals of the previous worksheet in the current one. | | Example: | | D5 of sheet Aug30 to D4 of sheet Aug29, ('Aug29'!D5) | D5 of sheet Aug29 to D4 of sheet Aug28, ('Aug28'!D5) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Flexible Cell Reference | Excel Discussion (Misc queries) | |||
reference cell value from fixed column with variable row | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Using the results from two seperate cells to create cell reference | Excel Worksheet Functions |