We have a Excel File (Number 1) with 9 columns. One of the columns is the ID
Need to generate a Excel file (number 2) with 4 columns. 3 of them are contained in the file number 1
To generate the missing column, need to:
- Create a catalog with a field called "PTN"
- Create a form where user will choose one of the PTN options.
- User will input several ID numbers. Script will look for the ID in the File number 1, and will create a excel row with ID, PTN and 2 other columns that match ID row.
If you are spanish speaker is a must, but it is not required.
Please write PM to send you excel samples and start this project.
30 freelancers are bidding on average $92 for this job
I UNDERSTAND ALMOST, BUT SOME QUERIES. BUT I THINK THAT CAN BE CLEAR AFTER WATCHING EXCEL.. PAY AFTER COMPLETING THE [url removed, login to view]