Member Since: 5th Sep 2001
7th Feb 2005
Excel consolidation of data
there are a couple of inbuilt Excel functions for this either- Data -consolidate
or Data - Pivot tables - multiple consolidation ranges
both work in a similar manner -- and are a bit fiddly to set up .
the online Excel Help is- in these cases quite usefull!
Because of the number of worksheets you MAy have to carry out the process in 2 or more steps- e.g. combine say 2 * 20 and 1*10 sheets and then combine these 3 summary sheets
22nd Jul 2004
Excelerator is an AGRESSO reporting tool based on Excel using Vi
Excelerator is an AGRESSO (copyright)reporting tool based on Excel using Visual Basic macro programming.