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 addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗