Synchronize Rows in Excel

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.

Habilidades: Processamento de dados, Excel

Veja mais: synchronize rows excel, excel synchronize rows, Synchronize, rows, check data excel files, check excel files, excel check double, excel data tables, excel check check, excel file data manipulation, index excel, synchronize file, excel manipulation, price file excel, excel data columns, excel row columns, rows excel, tables excel, report excel excel data, check date excel, report excel data, excel workload tracking example, vba excel rows html, combine multiple similar excel spreadsheets code example, excel product sheet example

Acerca do Empregador:
( 19 comentários ) Belize, Bulgaria

ID do Projeto: #5108224

Concedido a:


Hi there. This is easy for me and I can do it fast. I would like to send you your file back but you need to contact me. I had plenty of this kind of job on my fiverr page. If you want I can do this for you in Mais

$15 USD em 1 dia
(0 Comentários)

32 freelancers estão ofertando em média $25 para esse trabalho


I have done a sample file you have attached. Please download from here.. [login to view URL] Output sheet Column B-D has data you [login to view URL] two columns are helper colum Mais

$24 USD em 1 dia
(110 Comentários)

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [login to view URL] Looking for further discussions in this matter. with than Mais

$29 USD in 2 dias
(29 Comentários)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with posi Mais

$30 USD in 3 dias
(20 Comentários)

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 !

$25 USD in 3 dias
(43 Comentários)

sir, i am highly interested and dedicated to do this task. let's start. i am awaiting for your positive reply. thanks

$30 USD in 2 dias
(26 Comentários)

Dear itipoo1, Expert here.. Please award project. Bid: $28 Timeline - 1 day Regards, Microk [login to view URL]

$28 USD in 3 dias
(27 Comentários)

Hi, I have experience in job like this and I can do this job very fast, please contact me for details

$30 USD em 1 dia
(25 Comentários)

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n Mais

$25 USD in 3 dias
(22 Comentários)

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!

$25 USD in 0 dias
(7 Comentários)

PLEASE, CONTACT US FOR MORE DETAILS -------- [login to view URL] ------- Dear Sir/Madam, I am offerring you our services. You will have unlimited revisions and guaranteed quality as result. If you are not sattisfied with Mais

$30 USD in 5 dias
(1 Comentário)

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.

$27 USD in 0 dias
(12 Comentários)

I can help you within hours and with 100% accuracy. Please let me know if you're interested. Regards, quatroo

$25 USD in 0 dias
(4 Comentários)

Hi. I have read carefully and totally understand the requirement for the task. I'm a very careful and industrious worker. I can assure you I will finish it with 100% accuracy. I would appreciate it if you could conside Mais

$27 USD in 3 dias
(6 Comentários)

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.

$30 USD em 1 dia
(1 Comentário)

Ready to work on this.. will deliver project with in time. please assign to me. looking forward to work with you my skype id - [login to view URL]

$14 USD em 1 dia
(1 Comentário)

ok i can do it......i read ur file but also it have some viruses, thats why my system gives warning before editing..u can later discuss..

$25 USD in 4 dias
(1 Comentário)

hi, Can complete it with 100% accuracy. Do have 3 yrs work experience in excel. Completed engineering & MBA, which will help to add more value to project. Project Requirement :- -- Synchronizing columns from Mais

$25 USD in 3 dias
(1 Comentário)

I am a Copy Typing Freelancer and have ample knowledge and experience in this field. I have the power and ability to work honestly and reap in benefits for the company. Over the years I have worked for numerous employe Mais

$25 USD in 3 dias
(0 Comentários)

[login to view URL] As cheesy as it sounds ha!

$25 USD in 2 dias
(0 Comentários)

Hi ilipoo1, I understood your requests. I work with Excel daily and I can do the job. Best Regards, Marco Consorti

$25 USD in 2 dias
(0 Comentários)