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

Multiple Source Worksheets
 

Come On Geeks Sort It Out Put Some Effort In


---
Message posted from http://www.ExcelForum.com/

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

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/