Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with mastersheet
Greetings,
We are trying to analyze customer data.. For example: On a workbook, I have 8 sheets: 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008. Each sheet has below data: A1 B1 C1 D1 E1 F1 G1 == till N1 Subscription Number Subscriber Name Subscription Code Magazines Novels Comics DVD 01 Mike Bay7342M 4 2 8 1 02 Cyndi Dow8263L 1 1 20 0 I've manually copied all the sheets to a master sheet. Now I want to update the master sheet whenever a cell value changes in the individual sheets, so that the master sheet will give us the total number of books, mags etc., a customer has borrowed.. If you notice, we have a sheet "2008", right now it's blank but will be used in next year! Any help will be greatly appreciated. Regards Carlos |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mastersheet | Excel Discussion (Misc queries) | |||
Mastersheet update problem... | Excel Worksheet Functions | |||
Pulling data from sheet to mastersheet | Excel Discussion (Misc queries) | |||
create multiple worksheets from a mastersheet same workbook | Excel Worksheet Functions | |||
Copying sheets to a mastersheet Help needed | Excel Programming |