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

eggy_su

New Member
Joined
Sep 12, 2019
Messages
1
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=

Active Member
Joined
Dec 3, 2009
Messages
288
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
 

Forum statistics

Threads
1,084,970
Messages
5,380,918
Members
401,705
Latest member
DravenExcel

Some videos you may like

This Week's Hot Topics

Top