I have a global template financial report and I need to import various regional reports from around the globe into this standard format. What I would like is a way to map the regional reports to match the global template financial report. So that fields containing dissimilar data columns names but the same data could be easily matched up. For example:
Global Template Column Head Example Regional Report Column Header
Here we can see that the Global Template's "Narrative" column is equal to the Regional Report's "Description" column header field.
Now you may ask why not have everyone just populate the global standard template? Well that's what we're moving towards but this will take some time. In the meantime I need to away to consolidate these dissimilar regional reports into the global template. I suppose I could use MS Access to accomplish this but since my user is familiar with MS Excel I wanted to explore doing it with that app first.