1) Combine spreadsheets based on common file name attributes (add new data to existing sheets via copy paste).
2) Create new spreadsheet with all data on one tab, and pivot table on new tab.
3) Create 3rd tab with a copy paste of pivot table data so that 3rd sheet is static, not pivot table dynamic.
4) A GUI interface is needed to allow the user to select input and out put folders.
5) Macro must retain directory path after each time user changes it so that input/output directory paths can be reused by user if desired.
18 frilansare har i genomsnitt lagt bud på $133 för detta jobb
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Willing to take up your project. Thank you, Regards.