I'm trying to pull in data from another workbook using dynamically named ranges. I've done some searches but can't find any examples of what I'm trying to do.
Workbook_A has several tabs - each with a drop-down list that is used to select the week-end date. When a week-end date is selected a macro dynamically creates a named range based on the week. (For example, if 11/03/12 is selected a named range within that sheet is created with a name of 'Week45'.) I also place the name of that sheet's named-range in cell C4.
Workbook_B also has several tabs - and also has a drop-down list that is used to select the week-end date. (In this workbook I also place the week (in this example 'Week45') in cell C4.)
I could create a VLookup formula in Workbook_B to pull data from Workbook_A, but I need it to be dynamic based on the week-end date.
Is there a way to dynamically pull data from Workbook_A into Workbook_B based on the named range which is in cell C4? I've tried using the VLookup formula with an embedded INDIRECT formula but haven't had any luck.
Bookmarks