Dear All,
I'm New to VBA excel and would like to write a Code whereby:
1) Convert raw data(another Workbook)(repetitive "supplier" and "type", f) to Non-repetitive table.
2) Result Table with autosum(New Workbook) as below:
3) The Result table will be expanded with Raw Data future key in.
4) Any code help will much appreciated!
Regards
Su
I'm New to VBA excel and would like to write a Code whereby:
1) Convert raw data(another Workbook)(repetitive "supplier" and "type", f) to Non-repetitive table.
2) Result Table with autosum(New Workbook) as below:
3) The Result table will be expanded with Raw Data future key in.
4) Any code help will much appreciated!
Regards
Su