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.
32 freelancers estão ofertando em média $25 para este trabalho
hey ilipoo1, please correct me if wrong -> Only the dates which match should remain (columns A,C). Rest of them should be removed. Correct ? Meanwhile - which OS are you using- MAC or WINDOWS. please reply. thanks !
Hi. I can do this in about 1 hour. I have done alot of similar project. Input excel and write back or export to a new file. I am ready to do for you. You will have the best result. Thanks!
Hi! I understand what needs to be done and can do it. I'll write a VBA macro to automate and speed up the process and avoid errors. I have 12 years of extensive Excel and VBA experience.
Hello, I have 15 years of administrative experience and excellent Excell skills. I can do this job for you in about an hour. Thank you for your consideration.
Ready to work on this.. will deliver project with in time. please assign to me. looking forward to work with you my skype id - [url removed, login to view]