Hi,
First time post so hoping someone can help me. I have been advised that a VBA Macro would be the best option.
Using the data in excel, i need to create an excel macro to do the following
- Populates the table shown in the “Data” tab automatically using all the information within the “Original TB” tab
- Retains the original unedited version of the TB data received within the “Original TB” tab
- Creates a pivot table in the “Pivot” tab showing “Nominal” down the side, “fund” across the top and “amount” in the centre
- Updates the “Control” tab to show the individual who last ran the macro, the time and date they did, and how long this took to run
I'd appreciate any notes or assistance.
First time post so hoping someone can help me. I have been advised that a VBA Macro would be the best option.
Using the data in excel, i need to create an excel macro to do the following
- Populates the table shown in the “Data” tab automatically using all the information within the “Original TB” tab
- Retains the original unedited version of the TB data received within the “Original TB” tab
- Creates a pivot table in the “Pivot” tab showing “Nominal” down the side, “fund” across the top and “amount” in the centre
- Updates the “Control” tab to show the individual who last ran the macro, the time and date they did, and how long this took to run
I'd appreciate any notes or assistance.