Hi
I have data in column A7 AROUND 1500 ROWS. I usually filter this column via two colors Grey and Dark grey which then produces subtotals for all columns from V4: AG4. BUT I CHANGE filter either grey or dark grey the values at this range also changes.
I want to copy the range FROM V4:AG to another sheet say B10 for filter grey
and B11 when i filter via color for dark grey.
Please see the attachment.
Thank you all Experts in Advance
I have data in column A7 AROUND 1500 ROWS. I usually filter this column via two colors Grey and Dark grey which then produces subtotals for all columns from V4: AG4. BUT I CHANGE filter either grey or dark grey the values at this range also changes.
I want to copy the range FROM V4:AG to another sheet say B10 for filter grey
and B11 when i filter via color for dark grey.
Please see the attachment.
Thank you all Experts in Advance