I am looking for an experienced person to develop macro for a routine activity I perform in excel and source code should be summarized.
I also want the developer to explain how the source code is created so I can do small changes myself whenever is required.
Below are details of the file:
1) There is one sheet called additions tab which needs to be updated from different excel file (Additions File).
2) There is pivot based on additions tab which needs to be updated after the additions file is update with data.
3) There is a acquisition tab which needs to be updated from different excel file (Additions files).
4) There is one sheet called disposal sheet which requires updation from different excel file which is called (Gain or Sale).
5) There is final sheet called chargeable gain which requires updation of different coloumns from disposal and additions tab.
6) When the details are updated in chargeable gain then the data needs to be sorted in categories based on some rules which is based on some coloumns and same formulae is used for individual category.
It's only lot of copy pasting that's why I want to get it automated.