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

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

Fixed Price

Delivery by November 17, 2012

$30.00

Budget

Details

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.

Regards,

=======================================================

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.

Regards,

Open Attachment

Skills Required:

Client Activity on this Job

Last Viewed: 2 years ago

Proposals: 41

Hired: 1

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


About the Client

(4.97) 39 reviews

United States
Jacksonville 02:47 PM

99 Jobs Posted
65% Hire Rate, 2 Open Jobs

Over $10,000 Total Spent
71 Hires, 7 Active

$7.13/hr Avg Hourly Rate Paid
1,395 Hours

Member Since Aug 21, 2011