VBA Transform Data into Excel Table(No Repetitive Header and Future Expandable)

[eggy_su]

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

 

[=ODIN=]

It seems like what you are asking for could be done with a pivot table. Try putting your data from 1) into a pivot table then putting type into rows and supplier into columns