Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating regional summary data
I have a series of spreadsheets with state data. These need to be
aggregated into 4 regional sheets. I'm new to excel and not sure how to proceed. In a programming language I would simply have a list and sum the regional data. It seems this should be possible in excel. I would need to identify which spreadsheets (ie states) are in each region and have it consolidate these regions. Each state is contained in a workbook. Is consolidation the way to go? Consolidating each of about 25 workbooks into the regional information. Is there a way to have an array of state names and simply have excel loop through them, or do I need to hard code this. Thanks from someone new to excel. Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a summary sheet from data across multiple worksheets | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Creating multiple workbooks from summary workbook | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |