Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compiling data from multiple Excel sheets - macro?
Hi,
My lab is running a program that produces data for each file on separate work sheets with 54 lines of data per sheet. I now need to compiled all of the data from each sheet into one worksheet, with one row per file (one file=one person in research project). I've heard a macro is the way to do this but have little to no experience with this. My worksheets are piling up and I can't imagine having to copy and paste these every time! Any thoughts would be very much appreciated -- thank you in advance for your time!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compiling data from multiple excel files | Excel Discussion (Misc queries) | |||
Compiling data from many work sheets to one | Excel Discussion (Misc queries) | |||
Compiling data from multiple worksheets into one worksheet | Excel Discussion (Misc queries) | |||
Compiling information from multiple excel files | Excel Discussion (Misc queries) | |||
comparing and compiling between sheets | Excel Discussion (Misc queries) |