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)

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)