Macro - Data Transfer

[zkallen]

Hi

I'm trying to transfer some information from one tab to the other. The idea is that the raw data is dropped into a TAB1 and with the click of a run macro the information is dropped into TAB2 in the correct format. The total shipment value for each month will be calculated and fill the correct month column in correlation with the row containing the correct SKU number.

Any ideas?


*TAB1*

*TAB2*

 

[SeniorNewbie]

Hi,
of course a hand-taylored VBA solution may help, but in this case maybe PowerQuery is easier ...