Hi guys,
I have a sheet that takes a list of totals and asks the user to break down the totals into groups and descriptions.
For example:
Column B = Total to break down
Column C = Reconciliation showing amount missing from all columns to get back to match Column B.
Column D to E = Different employee names in Team A.
Column F = Sub-total for Team A.
Column G to L = Different employee names in Team B.
Column M = Sub-total for Team B.
Is there an easy way to allow the user to add their own columns which will also update the sub-total formula and update the reconciliation formula? If they manually add columns it doesn't always update the sub-total (depending where you add the column). They also need to add new teams, which will need to be reflected in the reconciliation formula. They may also need to be able to delete employees/teams.
I assumed Macros are the answer but I've never used them. If Excel has some functionality that gets me most of the way there without Macros -> bonus!
I have a sheet that takes a list of totals and asks the user to break down the totals into groups and descriptions.
For example:
Column B = Total to break down
Column C = Reconciliation showing amount missing from all columns to get back to match Column B.
Column D to E = Different employee names in Team A.
Column F = Sub-total for Team A.
Column G to L = Different employee names in Team B.
Column M = Sub-total for Team B.
Is there an easy way to allow the user to add their own columns which will also update the sub-total formula and update the reconciliation formula? If they manually add columns it doesn't always update the sub-total (depending where you add the column). They also need to add new teams, which will need to be reflected in the reconciliation formula. They may also need to be able to delete employees/teams.
I assumed Macros are the answer but I've never used them. If Excel has some functionality that gets me most of the way there without Macros -> bonus!