hi guys
I am struggling to get the data from one source WB to another destination new WB based on selection criteria with VBA.
the source WB is as follows
col1 col2 col3 col4
desc center receipt payment
AA 12 1 3
BB 13 2 4
AA 12 3 5
AA 13 6 7
AA 12 7 8
BB 12 1 2
AA 15 2 4
BB 10 1 5
BB 13 1 2
if we specify to get AA desc only it should be in new WB as with auto sum of receipt and payment and sorted ascending at "center"
desc center receipts payment
AA 12 11 16
AA 13 6 7
AA 15 2 4
if we specify to get BB desc only it should be in new WB as with auto sum of receipt and payment and sorted ascending at "center"
desc center receipts payment
BB 10 1 5
BB 12 1 2
BB 13 3 6
I am VERY thankful for your support.
I am struggling to get the data from one source WB to another destination new WB based on selection criteria with VBA.
the source WB is as follows
col1 col2 col3 col4
desc center receipt payment
AA 12 1 3
BB 13 2 4
AA 12 3 5
AA 13 6 7
AA 12 7 8
BB 12 1 2
AA 15 2 4
BB 10 1 5
BB 13 1 2
if we specify to get AA desc only it should be in new WB as with auto sum of receipt and payment and sorted ascending at "center"
desc center receipts payment
AA 12 11 16
AA 13 6 7
AA 15 2 4
if we specify to get BB desc only it should be in new WB as with auto sum of receipt and payment and sorted ascending at "center"
desc center receipts payment
BB 10 1 5
BB 12 1 2
BB 13 3 6
I am VERY thankful for your support.