Good afternoon,
I am hoping that someone can offer assistance writing a VBA command. The command aims to look through workbooks in a file path directory, find any workbooks that have a predefined numeric prefix, and copy their contents to tabs in an active workbook.
The active workbook will have a command tab and eight data tabs. Each data tab needs to be populated by data in an Excel workbook (all data workbooks have only one tab), saved in a file directory on my computer.
The numeric prefix, "12345" for example, will be dynamic and typed in to a cell in the control tab. There will be eight separate workbooks with each unique prefix in the file directory to be found and copied.
For example, using the numeric prefix 12345, the eight files would be called:
12345_AttributionCountry_GRPS.xlsx
12345_AttributionSector_GRPS.xlsx
12345_CharacteristicsRisk.EXP.xlsx
12345_CountryWeights.CLPSE.xlsx
12345_SectorWeights.CLPSE.xlsx
12345_TopBottomContributors.EXP.xlsx
12345_ValuationDetail.EXP.xlsx
12345_TradeActivity.EXP.xlsx
The contents of each of these should be copied in to the eight data tabs in the active workbook, with the tabs named in line with the above but without the numeric prefix (e.g. the first tab would be called "AttributionCountty_GRPS").
If anyone can help out it would be really appreciated.
Many thanks
Bookmarks