first please see attached JPG Screen shot which I need via VBA Macro
subject:- EXCEL MACRO- FIRST SORT ON COL.A,THEN B,THEN,C +
SUBTOTAL OF D,E,F BASED ON EACH CHANGES IN A THEN EACH CHANGES IN COLUMN B
I am in search for Excel macro
for above requirement.
(1) Total database just spread in in columns A to F
(2) Columns A's Data's End not fix (Dynamic)
(3) first-require macro for whole data Sort on A then Sort on B
(4) Requirement Subtotal should be in Columns D,E,F
(5) first of Each changes in Columns A-->> Subtotal columns D,E,F then by
(6) Each changes in Columns B-->> Subtotal columns D,E,F
that's it...Very simple & basic situation ...Require VBA Macro for above .
can anyone help me??