Completed

Excel data ediiting

We have 11 sets of customer lists in Excel and 11 related MS word documents which are the results of mail merging each of these 11 lists as address labels. This merge was done some time ago. When customers moved premises over time we deleted the label on the word document but left the excel spreadsheet unchanged. The excel spreadsheets therefore include the customers that have moved away.

We now want to update the excel spreadsheets (which is what we should have done all along !)

All we require you to do is to open the excel spread and the associated word document. It is obvious from the file names which excel file goes with which word file. Then scan the word document by eye and when you see a blank label find the corresponding record in the excel file and mark a new column titled "Gone Away" with a "Y". The word documents have the records in the same order as the spreadsheet reading across then down.

Do this for all 11 data sets. There are 2533 records in total, of which about 10% will be blank and need to be marked "Y" in the Gone Away Column.

Finally, merge all the eleven spreadsheets in to a single spreadsheet and add an extra column to indicate the source spreadsheet of the data.

As an example, suppose you worked on [login to view URL] and [login to view URL] and [login to view URL] and XYZ.doc.

The final result would be a single spreadsheet looking like this:

Source Name Address1 Address 2 ... Gone Away

ABC Electrical Ltd Apple Way Leeds

ABC Plumbers R Us Pear Ave Manchester Y

...

XYZ Builders Banana Way Liverpool Y

XYZ Sparkys Tomato Street Burnley

ABC/XYZ is the source spreadsheet name which is a new field. GoneAway is also a new field. Y means the record is absent in the word document.

I can send the files before you are committed but for privacy will not post publicly.

Thanks

Mike

Skills: Excel, Data Entry, Word

See more: excel data entry mail merge form, mail excel data, horse race results excel data, blast mail excel data, earn solving ms excel data, excel data entry customer support, excel data files customer lists, ms excel data cleansing, script search results excel data processing excel, use excel data direct mail, mail merge excel data entry, ms excel data entry asap, ms excel data entry web-research, ms excel data entry webresearch, ms excel daTA ENTRY, take ms excel data, working from home using your personal computer internet ms excel data entry jobs, MS EXCEL Data, Any project related to MS-WORD , MS-POWER POINT, MS-EXCEL -- DATA ENTRY

About the Employer:
( 88 reviews ) Castleford, United Kingdom

Project ID: #31928528

Awarded to:

Momalqadir

Hey Mike, I understood the work perfectly. I can start working ASAP. I will go through all 2533 records to make the required changes. Message me to get started right now. Thanks.

$50 USD in 1 day
(34 Reviews)
5.2

76 freelancers are bidding on average $118 for this job

(431 Reviews)
8.6
(648 Reviews)
8.7
BithiXpert

Hi, I can find blank row from word to excel and add new Colum and mark Y and marge all file perfectly. If you need any sample please let me know.

$100 USD in 1 day
(427 Reviews)
7.7
(475 Reviews)
7.4
shaily1227

Hi! I understand the project perfectly, you explained it so well with example too. So first I will find the contacts gone away in excel with the help of word file then merge it and consolidat in one file. I can ensur More

$100 USD in 2 days
(209 Reviews)
7.0
(358 Reviews)
6.7
(200 Reviews)
6.8
(131 Reviews)
6.1
AccountantArman

"Sir, I will merge all your 11 sheets into one sheet with proper formatting and as per your requirements. I am an Excel Advanced Level Expert. This is basic work for me. I can complete this project with added quality More

$88 USD in 1 day
(122 Reviews)
6.1
Stephenrajs

Hi there, I am offering my Services on short notice. Relevent skills and Experience Please consider me and give me a chance to impress you by my quality services. Please Check my mastery work at:- [login to view URL] More

$160 USD in 2 days
(116 Reviews)
5.7
khannajay65

Hello Sir, I understood the task i would like to work on your project i will add a column gone away in excel with y in it for customers who moved to new premises i am available now contact me for a free More

$70 USD in 2 days
(75 Reviews)
5.7
(73 Reviews)
5.5
ARTICLEYOUWANT

Hi Mike, I have understood your project details and ready to work accordingly for 11 excel sheets associated with 11 Ms word documents. I am comfortable to help you in updating the files with a total record of 2533. Pl More

$200 USD in 1 day
(30 Reviews)
5.6
merinsinha

I can do it. Excel Data editing Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anti More

$98 USD in 2 days
(125 Reviews)
5.4
ginushaji3

I can finish it early. Contact me for further deliberations................................... Regards Ginu

$140 USD in 7 days
(24 Reviews)
4.6
(19 Reviews)
4.9
raghibmth

Sir, Expert in data excel sheet work... I have clearly read and understood the description of this project. I'm confident to do this work better and also on time with revisions. Be sure to get quality work and reliabl More

$30 USD in 1 day
(51 Reviews)
4.5
pranotosh

Hi Mike, I'm a Web Developer having experience in Web Searching, Web Scraping, Data Entry, Data Processing, Excel, MS Word, PowerPoint etc. I can assure you quality work with 100% accuracy. Ready to start right now. L More

$50 USD in 2 days
(21 Reviews)
4.6
bindhyaashish

I have read your project details and I can do this as per your requirements. I have more than 15 years of experience in Ms word, Ms office. Please contact me

$90 USD in 7 days
(2 Reviews)
4.3
monicawriter99

Hi! I've carefully checked your requirements and really interested in this project Excel data ediiting. I'm a full-time data and statistical analyst. I have worked with many clients from the U.S. and European teams. More

$200 USD in 2 days
(14 Reviews)
4.1