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.