Multiple Source Worksheets

  • Thread starter Thread starter robeves
  • Start date Start date
R

robeves

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
 
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
 
Back
Top