Hi all, I have attached 2 files to this advertisement:
(1) [url removed, login to view] [This contains 14 excel files]
(2) [url removed, login to view] [This is where i want the data to be in]
More in depth description/deliverables:
(a) The data in 14 [url removed, login to view] will be obtained every hour. The data will be stored in a specified folder.
(b) I need the vba code to be in the template to be able to pick up data from the 14 files every hour.
E.g., @ 01 August 2010 17:00 hrs it will go to the folder and retrieve all relevant data from the 14 files and copy and paste in the correct sections (so on and so forth till the end of the week). So every hour of the week (it will access each of the 14 files and paste the data into the relevant spreadsheet in Template.xlsx.
You will notice that there are 2 spreadsheets (Sell and Buy Currencies) with 7 sections of space each, to allow the VBA code to copy and paste the data.
(c) Please provide some documentation so i can submit this as a project.
P.S. Please send me the rough estimate of the cost of this program
15 freelancers are bidding on average $72 for this job
Hi, I have the right skills on VBA and MS-Excel to help you on this project. Please provide me an opportunity and I will ensure the task is completed to you satisfaction.
Hi. This project will require a combination of vlook formulas, data import/query, and a macro to auotmate. I'm very happy to undertake this in exchange for positive feedback/ratings only. Happy to discuss.