I have 39 excel files, in each file, there are 4 columns with data , about 3500 rows. The first 2 columns are Date and Price, the second 2 are Date and Index.
I need someone to synchronize the files, so that the dates are the same with the numbers for price and index. Now some of the cells are empty, or with *, or sometimes there is Index info but no Price info. I want only rows where there is both Index and Price. The other should be deleted. All data must be accurate as its now. Only manipulation should be done, so rows where Index or Price doesn't exist, to be removed. I also need report on which rows were deleted for each of the files (with the row info before that).
I will double check the files to make sure it all fits. I attach here example file.
Only the Tables with- "True" in the name, should be manipulated.
Don't bid if you don't understand 100%, what's the task. Message me if you have questions.
15 freelancers are bidding on average $1481516 for this job
I'm a VBA expert I will deliver a macro hat will be able to process your files meeting the criteria explained above, thanks for considering my proposal.
I just hate spammers. Better you get some original work and post your own genuine projects. You are new to freelancer and you must know the terms and conditions of it before you do anything wrong here.
Hello, I will complete your project within 24 hours maximum. I am the perfect fit for the job since I work daily with excel (formulas, data formatting etc). Hope to hear from you Thanks
Hello sir, I understand the task at hand and it's possible to resolve in a precise manner by using computer programming. This way I can deliver exactly what you need, Thank you.
I have big experience of data entry. I work fast and accurately. I can guaranty high quality and work done on time. I fully understand your task and ready to start.
Hello. Will gladly help you with this project. Looks pretty simple from what is described, so shouldn't take more than few hours. Thanks in advance! Artem Koloskov.