I have an excel file with multiple (more than 20) spreadsheets, each spreadsheet contains some data. I need to create a macro that will copy three columns that are located at different locations from each spreadsheet and paste the data from the three columns into another summary spreadsheet.
The macro must be able to update the summary spreadsheet when I make changes in the multiple (more than 20) spreadsheets and also copy three columns when I add a new sheet.
16 freelancers are bidding on average $103 for this job
Hi, I have over 8yrs of experience working with excel macros and formulas. I would like to take up this project. Please provide me some sample data so we can get started. thanks & regards
I can take of this immediately and have extensive experience with excel in nearly every IT job I have held. My bid is relatively low as I am new to Freelancer and am looking to get some work to develop a reputation.