| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
70 WORKBOOKS - NEED PIECES OF DATA FROM EACH TO FORM LIST
I have 70 workbooks, each for different customer containing identical
worksheet - with customer specific data. How can I get 15 pieces of data from each identical worksheet into one worksheet in a list format? I tried consolidate - but either I didn't do it right or it is just as manual as copy/paste would be. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals in a list | Excel Discussion (Misc queries) | |||
| using list box to edit or select data | Excel Discussion (Misc queries) | |||
| Data Entry Form | Excel Worksheet Functions | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Create template that ignors data list rules | New Users to Excel | |||
Threaded Mode
