Hi All Guys
I have to 2 format templates sheets but same principle apply for both
Make a subtotal of Tariff description origin header as the primary key with qty litres sugar and amount
the other format does not contain litres and sugar but header column slightly differ see attached sheet
One sheet expected results column headers O,P,S,T
ANOTHER WORKBOOK sheet expected results column HEADERS L, M N O T V.
Actually doing manually with subtotals, F5 SPECIAL VISIBLE CELLS AND COPY REQUIRED HEADERS TO SUMMARY.
Looking for a macro to make dynamic subtotals for these colums mentioned above and then transfered it summary sheet for further process as it is repetitive process each time so as save me time I am overloaded andme crazy
Note the subtotals can reach up 900 subtotals with a data set of 10000 to to 15000 rows .
Hope anyone who knows vba to help me in this tedious task am looking looking to automate this process
http://www.mrexcel.com/forum/excel-q...-criteria.html
Bookmarks