• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

2 macros need to be wriiten for mapping of fields to another need urgent help.

priya2208

New Member
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.
 
Have you looked into setting up a Query based on another XL file? That would let you choose what fields you want and filter/arrange them as desired. The query wizard is fairly intuitive.
 
Back
Top