Update Customer Contacts Between Sheets

₹400-750 INR / hour

Posted 1 minute ago

•

Ends in 6 days

₹400-750 INR / hour

I have two spreadsheets that hold overlapping customer records. The master sheet is missing some up-to-date contact details, while a second file contains the correct information. Your task is to take the name, phone number, and email from the second file, match each record to the master sheet by Customer ID / account number, and then overwrite the outdated fields. You may work in Excel or Google Sheets—whichever you’re most comfortable with—so long as the final deliverable is an updated version of the master file that opens without issues in both environments. Acceptance criteria: • All contact fields (name, phone, email) updated wherever a matching Customer ID is found. • No accidental changes to any other columns or formatting. • A simple change log (tab or separate file) listing each Customer ID you updated, with old and new values. • A brief note on any Customer IDs found in one sheet but not the other. Once everything is confirmed, send back the revised master sheet and the change log. I’ll handle the rest.

Project ID: 40829868

About the project

Open for bidding

Remote project

Active 57 yrs ago

Place your bid

Bid amount Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

用 HomepageTab 新标签页关注 RSS,打开浏览器就能看到更新。

安装 HomepageTab