Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining multiple spread sheets into one | Excel Discussion (Misc queries) | |||
Multiple Excel Spread Sheets | Excel Discussion (Misc queries) | |||
Can I unstack multiple spread sheets in Windows XP? | Excel Worksheet Functions | |||
Run macros on data spread across multiple spreadsheets | Excel Discussion (Misc queries) | |||
Automatic comparison and uploading of data among 2 spread sheets | New Users to Excel |