Automate Excel Data Matching: Buying vs Sales
Budget: $10 – $30 USD
"Excel Data Automation for Matching Buying & Sales Rates by Date"
Description
"I need an Excel expert to automate data matching between two Excel files:
1. Vendor Buying File: Contains part numbers and buying rates.
2. Company Sales File: Contains the same part numbers and sales prices.
Your task is to:
Set up an automated solution to match parts and prices between the two files based on part numbers and date.
Transfer buying rates into the sales file or create a consolidated report.
Ensure the solution is easily updatable as new data comes in.
Skills Required:
Excel Power Query
Data automation and merging
Strong understanding of date-based data matching
I am based in Pakistan, and my files are structured with buying rates highlighted in green in the vendor file."
Requirements
Prior Experience: Share examples of similar work or automation you've done.
Availability: Specify if you’re able to complete this in 1 days.
Deliverable: A completed, fully automated Excel solution, with a quick guide for updates.
Description
"I need an Excel expert to automate data matching between two Excel files:
1. Vendor Buying File: Contains part numbers and buying rates.
2. Company Sales File: Contains the same part numbers and sales prices.
Your task is to:
Set up an automated solution to match parts and prices between the two files based on part numbers and date.
Transfer buying rates into the sales file or create a consolidated report.
Ensure the solution is easily updatable as new data comes in.
Skills Required:
Excel Power Query
Data automation and merging
Strong understanding of date-based data matching
I am based in Pakistan, and my files are structured with buying rates highlighted in green in the vendor file."
Requirements
Prior Experience: Share examples of similar work or automation you've done.
Availability: Specify if you’re able to complete this in 1 days.
Deliverable: A completed, fully automated Excel solution, with a quick guide for updates.