Hi All, I'm having a problem with the import of data.

I have a worksheet that is part of a large workbook the workbook itself is started weekly from a master book so all formatting etc is the same but the name of the file changes based on week ending value. In this workbook are the daily and then weekly summary figures for a business. I would like to be able to import from an older workbook into the weekly summary worksheet the exact same figures below the new ones. So that I can compare year to year figures. I am not sure if its possible to also get a button which when pressed will then pop up asking for the location of the "older" file. Or if it is possible to use compare equations for figures before the import has begun but first things first.

Thank you in advance.


Point of note, the structure of the workbook is always the same, just actual file name changes. E.g
"c:\user\documents\takings WE 27-01-11.xls" would be the file name that changes but the worksheet names "Mon", "Tue",...,"Weekly Summ" stay the same week-to-week