rohit1409
08-28-2016, 10:59 PM
Dear All Macro Guru's,
I have a file in the following format
A B C D
1 CostCentre Basic HRA Fixed
2 880001 3000 1000 1500
3 880002 4000 2000 2500
4 880003 1000 5500 3500
5 880004 400 200 4500
6 880005 500 750 500
Output required using macro...
CostCentre Account Amount
880001 Basic 3000
880002 Basic 4000
880003 Basic 1000
880004 Basic 400
880005 Basic 500
880001 HRA 3000
880002 HRA 4000
880003 HRA 1000
880004 HRA 400
880005 HRA 500
880001 Fixed 1500
880002 Fixed 2500
880003 Fixed 3500
880004 Fixed 4500
880005 Fixed 500
Now the catch is "cost center" field is not fixed and nor does the "account heads" fields Basic, HRA, Fixed.. these can be more or less... the range can extends to 50 cost centers and 25 account heads...
Request you to kindly suggest a macro for the same... appreciate your help here...
Please let me know if any other information is required... Thanks
I have a file in the following format
A B C D
1 CostCentre Basic HRA Fixed
2 880001 3000 1000 1500
3 880002 4000 2000 2500
4 880003 1000 5500 3500
5 880004 400 200 4500
6 880005 500 750 500
Output required using macro...
CostCentre Account Amount
880001 Basic 3000
880002 Basic 4000
880003 Basic 1000
880004 Basic 400
880005 Basic 500
880001 HRA 3000
880002 HRA 4000
880003 HRA 1000
880004 HRA 400
880005 HRA 500
880001 Fixed 1500
880002 Fixed 2500
880003 Fixed 3500
880004 Fixed 4500
880005 Fixed 500
Now the catch is "cost center" field is not fixed and nor does the "account heads" fields Basic, HRA, Fixed.. these can be more or less... the range can extends to 50 cost centers and 25 account heads...
Request you to kindly suggest a macro for the same... appreciate your help here...
Please let me know if any other information is required... Thanks