Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Source Worksheets
Look Geeks This Is Important
I have multiple worksheets, each relating to an individual class in year group. I want to be able to group these all together on a overview worksheet, i.e. for the sheet to reference each class i order, updating the overview, if a new class member is added automatically. I also want the overview sheet to be sorte alphabetically using the multiple sources. Cheers Geeks -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Source Worksheets
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Source Worksheets
After lots of years' experience, I would recommend changing you
approach to a more "database" set up by adding all your data to single table. The headaches and innacuracies saved more than compensat for the relatively small initial effort involved. All new data can the be added to the bottom of the table, and something like a simple Pivo Table refresh will update everything. The basic setup would be :- 1. An unformatted table in Excel (if record count will be less tha 65,535) or link to Access. 2. Pivot Table(s) - don't waste time trying to format these. 3. An Excel spreadsheet linked to the PT to analyse/summarise data Much better and easier than trying to do this in Access -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Source Worksheets
Hey Scarecrow. Read and heed what Brian says.
-- Regards, Tom Ogilvy "robeves" wrote in message ... Come On Geeks Sort It Out Put Some Effort In --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to populate different worksheets from a source worksheet. | Excel Worksheet Functions | |||
chart with data source from multiple worksheets | Excel Discussion (Misc queries) | |||
Pivot Table with source spread across multiple worksheets | Excel Worksheet Functions | |||
Change external data source for multiple worksheets | Excel Discussion (Misc queries) | |||
Multiple worksheets as the source for a pivot table | Excel Discussion (Misc queries) |