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
|
|||
|
|||
hi,
on sheet Aug29 at D4 put this =Aug30!D5 REgards FSt1 "Raja" wrote: 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) |
#3
|
|||
|
|||
Personally I would consider storing all your data on a single sheet and
adding a field for the day. That way you can use Pivot tables and other features/functions to analyse your data far more easily than when they are on separate sheets. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "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 | |||
Cell Reference help required | Excel Discussion (Misc queries) | |||
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) |