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 · Accepted solution]

@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.

[KGT]

What you're talking about is dynamic workflows. Here is a training on it from a few years back. There should be many around to give you ideas as well. You can go as deep as you need, but if it's 6 months worth of data, I imagine each month isn't too different.

You'll need to address each item that may change, sometimes "2 birds with one stone", but making sure each possible change is addressed. Changing sheet names in xls (not xlsx) files will be your possible biggest hurdle if you don't have control over that file generation.