I have two spreadsheets that are output [login to view URL] each have a name that changes with each daily output.
One sheet includes a column of "file number" and a blank column of "ID", as well as other columns of data.
The second sheet includes the same "file number" data, and the "ID" column, with data entered, as well as other columns of data.
I want a program I can run that will apply VLOOKUP to populate the "ID" data from the second sheet into the first sheet's empty "ID" column, in the same row as the corresponding "file number", and save the updated sheet with a new name.
54 freelancers are bidding on average $316 for this job
Hi, I am good at Excel and vba. Looking forward to discuss further in the chat. Please share me the file to work on. I can write script that transfer the data automatically. -Chandra
Hello, I’m an Excel/VBA expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
Very interesting project. It can be built using VBA macros and an option placed in the ribbon to trigger the action if you like, or it can be done as a standalone application