Encerrado

Synchronize Rows in Excel - repost 2

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, Processamento de dados, Excel

Ver mais: synchronize rows excel repost, double data entry excel, synchronize, rows, excel synchronize rows, synchronize rows excel, check data excel files, check excel files, excel check double, check data entry report, excel file data manipulation, index excel, synchronize file, report check data entry, excel rows, excel manipulation, check report data entry, price file excel, data report excel, data entry true, collection excel rows, excel row columns, paste excel rows project, rows excel, tables excel

Acerca do Empregador:
( 0 comentários ) Palakkad, India

ID do Projeto: #5110406

16 freelancers estão ofertando em média $1388935 para este trabalho

redmapleleaves

hi, sir, i' m master design and copy typing..... i have many excellent experts for excel, typing, photo,... i can help you well. we can do it in time. pls, hire. regards.

$222 USD in 3 dias
(3 Comentários)
2.7
guptaakash250

I have very strong knowledge of excel and i can do this work very easily and in very shortest time. Give me one chance for seeing my work

$25 USD in 2 dias
(1 Comentário)
0.1
saktulgasaktulga

I am an excel expert who can do this for you. It should not take more than 2-3 hours. Please contact me

$30 USD in 3 dias
(1 Comentário)
0.0
yprakasarao

I would like to take up the work as i am interested in joining the community of freelancers. I have done similar work earlier for my personal projects.

$10 USD in 3 dias
(0 Comentários)
0.0
Anuj33

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.

$22222222 USD in 70 dias
(0 Comentários)
0.0
palsubhamoy1985

The requirement is understood and can be achieved by an excel macro coding which will run for any number of excel files with similar structure. I will create the macro in a different excel sheet which will call all th Mais

$27 USD in 2 dias
(0 Comentários)
0.0
CARLOSHUGGINS

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.

$54 USD in 5 dias
(0 Comentários)
0.0
Dimciu

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

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

A proposal has not yet been provided

$10 USD em 1 dia
(0 Comentários)
0.0
Lkannus

I'm proficient with Excel, and I completely understand what you need from this project. I can easily do it. I'm very detail oriented, efficient, dependable, and professional. I'm bidding far below the value of my work, Mais

$10 USD em 1 dia
(0 Comentários)
0.0
hafizahayob

I don't find any attachment. Could you please email me the attachment? Kindly email it to me? Regards, Hafizah Ayob

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

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.

$220 USD in 3 dias
(0 Comentários)
0.0
ENRICOJ

IM READY. Mais

$30 USD in 0 dias
(0 Comentários)
0.0
SuperQuack

Sounds pretty simple. You can count on me! Also, if you want the source code or want me to show you how to run it on your own, let me know

$25 USD em 1 dia
(0 Comentários)
0.0
tatyana27

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.

$15 USD in 5 dias
(0 Comentários)
0.0
ArtemKoloskov

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.

$15 USD in 0 dias
(0 Comentários)
0.0