I have a wsheet (Claim Values)that contains tables of claimable $values; each week, a new table is created with new values for claiming.
The tables remain the same row and column size with a progressive $value subtotal change each week.
I need to be able to select the positive value sub-totals (non $zero) only and transfer them into a print sheet for each weekly claim.
I have spent some time browsing the messages but I can't find what I'm looking for.
Help will be much appreciated.
Thanks AndyW
ps very little vba & macro exposure...need it in small sylables!
The tables remain the same row and column size with a progressive $value subtotal change each week.
I need to be able to select the positive value sub-totals (non $zero) only and transfer them into a print sheet for each weekly claim.
I have spent some time browsing the messages but I can't find what I'm looking for.
Help will be much appreciated.
Thanks AndyW
ps very little vba & macro exposure...need it in small sylables!