INPUT Data - Scenarios

suby

Hi All,

I have a scenario where we have a workbook with one worksheet on it currently but things will change going forward like

 - New Columns will be added /

- Existing columns could be Renamed

- New Worksheet will be added to the Workbook.

I'm looking for  some thoughts on how to approach this on how to input the data is it Dynamic input will fit my Scenario or I have to use some other batch macros to achieve this.

Finally at the end of the day we would like to combine/Union 6 Month end Snapshot Data into One.

Any thoughts would be much appreciated.

Thanks

OTrieger

@suby 
Import the List of Sheet Names and then replace <List of Sheet Names> with the actual sheets name and get a Batch Macro to get all the data extracted from all the sheets.

You can make a mapping file indicating the different naming for each header and then use the dynamic rename tool to translate the new headers to the standardize one and by these 2 things you solved your issue.