Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to pull data out of an excell file with multiple tabs
I have 65 files with 20-40 worksheets in each file. I need to extract the
same range of data from all worksheets into a single Excel file. Any ideas? |
#2
|
|||
|
|||
Record a macro while manually doing two or three files, then edit the macro
to accomodate all the others.......... Vaya con Dios, Chuck, CABGx3 "mdeanda" wrote in message ... I have 65 files with 20-40 worksheets in each file. I need to extract the same range of data from all worksheets into a single Excel file. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Convert a word address and data list to excell | Excel Discussion (Misc queries) | |||
Getting data from another excel file | Excel Discussion (Misc queries) | |||
F7 in zip field when doing mail merge from excell file | Excel Discussion (Misc queries) | |||
saving dbf file without losing data | Excel Discussion (Misc queries) |