Take two excel files (xlsx or csv) and combine them into one and build a pivot

Web & Mobile Development Other - Web & Mobile Development Posted 3 years ago

Fixed Price

Budget: $30
Delivery by November 17, 2012

Start Date

October 21, 2012


Take two excel files (xlsx or csv) and combine them into one and build a pivot.

Basically, we have sales coming from one file. We have inventory coming from another file.

We want to build a combine spreadsheet in a very specific format to combine sales and inventory data into a single view.

New products will be introduce, new stores will be introduce. So, this should be dynamic.

Attached is what we want at the end.

Please bid if you have a EASY AND SIMPLE solution to the task.

Attached is a file that is an end product.

We will provide 2 raw files (one providing inventory and one providing sales data) to people who can deliver the end product.



ADDITIONAL NOTES: Just to be clear, this has to be a macros driven process to load and combine and format the data in final form. Some of the developers are thinking this is simply report creation but i can easily do myself.

The end product is Excel, it will be nice to have the capability of loading both files into the final excel and building the pivot displayed in the file attached.


  • Other Skills:

Activity on this Job

Last Viewed by Client: 3 years ago

Hired: 1

Other open jobs by this client ({{ jobsCount }})

About the Client

(4.97) 49 reviews

United States
Jacksonville 05:27 PM

116 Jobs Posted
64% Hire Rate, 1 Open Job

Over $40,000 Total Spent
92 Hires, 16 Active

$6.37/hr Avg Hourly Rate Paid
4,839 Hours

Member Since Aug 21, 2011