linking multiple workbooks that change names weekly

bucci35

Active Member
Joined
Jul 6, 2002
Messages
319
I have multiple workbooks with names like 05_091606. The 05 refers the store which will remain constant. The last 6 numbers refer to the week date which will change weekly. Any ideas on how i can link these weekly to one workbook while the names are changing weekly? I have 15 workbooks.

Dan
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,114,381
Messages
5,547,613
Members
410,803
Latest member
lsweeney
Top