Need Excel Macro created to Format data to a new spreadsheet
Budget: $10 – $30 USD
I have a form that people fill out. I need the data formatted to fit the format of my import file. Please watch the video and you can see how I need the information formatted. I need a macro created so when i click run it will output the correct file I need.
I need this completed in the next few hours.
Attached is an example of how the data comes in labeled Input, and the 2nd attachment labeled output is how i need the information outputted to.
https://www.dropbox.com/s/uhckz2yk2h20ckp/MAcro%20video.mp4?dl=0
I need the following columns filled in on the output file:
A - attendeeFirstName
B - attendeeLastName
C - attendeeEmail
D - attendeePhoneNumber
E - attendeeJobTitle
G - Groups (Hardcode this as Exhibitor)
H - organizationName
J ( Map from Column E on input file)
P (This is Organization Profile, map this from Column D which is company BIO)
I need this completed in the next few hours.
Attached is an example of how the data comes in labeled Input, and the 2nd attachment labeled output is how i need the information outputted to.
https://www.dropbox.com/s/uhckz2yk2h20ckp/MAcro%20video.mp4?dl=0
I need the following columns filled in on the output file:
A - attendeeFirstName
B - attendeeLastName
C - attendeeEmail
D - attendeePhoneNumber
E - attendeeJobTitle
G - Groups (Hardcode this as Exhibitor)
H - organizationName
J ( Map from Column E on input file)
P (This is Organization Profile, map this from Column D which is company BIO)