Data collection from multiple excel spread sheets
How do you collect data form multiple excel spread sheets? For example I
would like to find a name of a student and collect all of the final grades form different teachers excel gradebooks. |
Data collection from multiple excel spread sheets
To get a value from a different file, if you know the cell, you would do the
following: Suppose what you want is in cell B5 on Sheet1 in Book1, the value is: =[Book1]Sheet1!B5 Also, this can be done by simply typing "=" and then pointing to the value you wanted from Book1. Now, this may not be a big help because you may want to look up the values. In that case it would depend on how the files are set up, whether they're all set up the same way, and what your lookup values are. If every file is set up with things in exactly the same position, you could use a sum of formulas similar to the one above. Since that's unlikely, you will probably need to use VLookup and still have a sum of VLookups for your formula. "HSprincipal" wrote: How do you collect data form multiple excel spread sheets? For example I would like to find a name of a student and collect all of the final grades form different teachers excel gradebooks. |
Data collection from multiple excel spread sheets
Hi HSprincipal
Maybe the filter example will help on this page http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "HSprincipal" wrote in message ... How do you collect data form multiple excel spread sheets? For example I would like to find a name of a student and collect all of the final grades form different teachers excel gradebooks. |
All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com