En cours

Combine Excel Files

I have a project with two parts that are very similar. The first part of the project has 34 Excel Files that need to be reformatted and then combined and the second project has 100 Excel files that need to be reformatted and then combined. I have attached sample files for review.

Part #1 Instructions (SpeakerBureaus .xls Files):

1) Open the .xls file

2) VERY IMPORTANT - Select all of the text by clicking on the box right above the "1" for the first row and to the left of the "A" for the first column. There is a little triangle in that box. Next click on "Format" on the menu, then while on the "Number" tab (the first tab) select "text" from the category list and click OK. It souds like a lot but it is a very quick step.

3) VERY IMPORTANT - Scan all the way down while checking the State column and make sure the state is not missing. If it is missing, fill in the missing state columns with the same state from the other records. All of the states should be the same.

4) Save the file and close. Repeat these steps on the next file in project #1.

5) Once all individual files have been completed, combine the files into one big file and name it [url removed, login to view]

6) Send me an email with a zip file that contains the combined file and the 34 reformatted files.

Project #2 Instructions (Chamber of Commerce .xls Files):

1) Open the .xls file

2) VERY IMPORTANT - Select all of the text by clicking on the box right above the "1" for the first row and to the left of the "A" for the first column. There is a little triangle in that box. Next click on "Format" on the menu, then while on the "Number" tab (the first tab) select "text" from the category list and click OK. It souds like a lot but it is a very quick step.

3) VERY IMPORTANT - Scan all the way down while checking the State column and make sure the state is not missing. If it is missing, fill in the missing state columns with the same state from the other records. All of the states should be the same.

4) Save the file and close. Repeat these steps on the next file in project #2.

5) Once all individual files have been completed, combine the files into one big file and name it [url removed, login to view]

6) Send me an email with a zip file that contains the combined file and the 100 reformatted files.

Pre-Qualify Step (Should take less than 2 minutes):

In order to be considered, please combine the two sample files using instructions for part #2. Then post your results so we can confirm that you have completed the work properly before we award the project to you. It is VERY important that all steps are followed and we will check the work and payment will only be made if the steps are followed exactly.

Compétences : Saisie de Données, Traitement de Données, Excel

Voir plus : less excel, excel less, attached files, triangle, send email excel, save excel, files email, combine, combine excel, quick excel, combine order, excel contains, commerce data entry project, scan excel data, check data excel files, send email using excel, excel row column, text box excel, excel right click, files missing, file menu save, missing columns data, scan text, excel column row, right triangle

Concernant l'employeur :
( 42 commentaires ) St. Peters, United States

N° du projet : #1677182

Décerné à :

betteron

Seems like a simple straight forward job. I have time to fulfil the task today. I did the sample files and am ready to continue right away! Hope to hear from you soonest. see PM for the file

30 $ USD en 1 jour
(3 Commentaires)
3.2

11 freelance ont fait une offre moyenne de 68 $ pour ce travail

Teloquence

Consider it done. Check your PM for my bid details.

100 $ USD en 2 jours
(139 Commentaires)
6.4
nikhil08

Hi, Ready to start, Please check Inbox for details.

50 $ USD en 1 jour
(69 Commentaires)
6.2
Data1234

Hello, samples are attached in your personal message box. Thank you

45 $ USD en 2 jours
(60 Commentaires)
5.4
coolbuddy19

Hi I am confident to handle this

37 $ USD en 15 jours
(21 Commentaires)
4.9
qualitywork09

Please refer your PMB. Regards!

80 $ USD en 2 jours
(26 Commentaires)
4.7
karthik427

Hi,Please check your message box for Pre-Qualify Step.I can complete it in a few hours from now.Ready to start.

50 $ USD en 0 jours
(27 Commentaires)
4.6
simplegirl

hello, I'm interested to work on this project.

30 $ USD en 0 jours
(18 Commentaires)
4.2
ahad3750

Hi, i am ready to work with u

150 $ USD en 4 jours
(0 Commentaires)
0.0
mianahsan

hello sir i will do your project in just 5 days Regards Ahsan

100 $ USD en 5 jours
(0 Commentaires)
0.0
yuvajebaraj

Hi Sir / Madam I am Jebaraj From India.I am ready to start the task.Please send your further docs to start the task Jebaraj

75 $ USD en 1 jour
(0 Commentaires)
0.0