1. We create one excel file having 3 colmuns output file headers, mapping, input file headers
2. Need to write macro such that under output file header column all the header fields name from svc excel file(inputdata worksheet) comes
3. Same for input data field column (all header fields names come from requested_data file)
2nd 3 points - 1 macro
Then user himself will do mapping of thes e columns in mapping column
Then we need another macro such that after user completed mapping he press button (wriiten maro within it) mapping part done.
2. Need to write macro such that under output file header column all the header fields name from svc excel file(inputdata worksheet) comes
3. Same for input data field column (all header fields names come from requested_data file)
2nd 3 points - 1 macro
Then user himself will do mapping of thes e columns in mapping column
Then we need another macro such that after user completed mapping he press button (wriiten maro within it) mapping part done.