Đang Thực Hiện

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.

Kỹ năng: Nhập liệu, Xử lí dữ liệu, Excel

Xem thêm: 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

Về Bên Thuê:
( 42 nhận xét ) St. Peters, United States

Mã Dự Án: #1677182

Đã trao cho:

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 trong 1 ngày
(3 Đánh Giá)
3.2

11 freelancer đang chào giá trung bình $68 cho công việc này

Teloquence

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

$100 USD trong 2 ngày
(139 Đánh Giá)
6.4
nikhil08

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

$50 USD trong 1 ngày
(69 Đánh Giá)
6.2
Data1234

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

$45 USD trong 2 ngày
(60 Đánh Giá)
5.4
coolbuddy19

Hi I am confident to handle this

$37 USD trong 15 ngày
(21 Đánh Giá)
4.9
qualitywork09

Please refer your PMB. Regards!

$80 USD trong 2 ngày
(26 Đánh Giá)
4.7
karthik427

Hi,Please check your message box for Pre-Qualify Step.I can complete it in a few hours from [url removed, login to view] to start.

$50 USD trong 0 ngày
(27 Đánh Giá)
4.6
simplegirl

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

$30 USD trong 0 ngày
(18 Đánh Giá)
4.2
ahad3750

Hi, i am ready to work with u

$150 USD trong 4 ngày
(0 Đánh Giá)
0.0
mianahsan

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

$100 USD trong 5 ngày
(0 Đánh Giá)
0.0
yuvajebaraj

Hi Sir / Madam I am Jebaraj From India.I am ready to start the [url removed, login to view] send your further docs to start the task Jebaraj

$75 USD trong 1 ngày
(0 Đánh Giá)
0.0