Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find matching tab names between different workbooks
I have a workbook (lets call it Filter.xls) containing several tabs with
different names, lets say: 111111, 222222, and 333333. The Filter.xls file contains formulas which are applied to records of numerical data obtained from separate works (lets call them Data1.xls, Data2.xls, Data3.xls, etc.) containing several tabs with different names like 111111, xxxx, 222222, xxxx, 333333, xxxx. All aforementioned files would be in the same working folder. What Id like the VBA code to do is to cycle through any existing Data[#].xls files and check if there are matching tab names between them and the Filter.xls file and, if so, copy the record set from the matching tab in the Data[#].xls file to the matching tab in the Filter.xls file. I already have code to copy the record set from the Data[#].xls file into the Filter.xls file but what I am missing is the code that determines if there is a match between the tabs in the Filter.xls file and any available Data[#].xls file. If there is no match then notify the user and exit. Id appreciate anyones assistance. Please contact me if you need further details. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find matching data in two workbooks | Excel Worksheet Functions | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
Find names of all open workbooks | Excel Programming | |||
Conditional Format - 2 lists of names to find matching cells. | Excel Worksheet Functions | |||
Matching Names in two different workbooks | Excel Discussion (Misc queries) |