i want to copy rows given that:
1. Both Columns D & E are "TRUE", and
2. Both Columns D & E are "FALSE"
and paste it to another sheet
Thanks in advance!
i want to copy rows given that:
1. Both Columns D & E are "TRUE", and
2. Both Columns D & E are "FALSE"
and paste it to another sheet
Thanks in advance!
use auto filter ,filter d on true, then filter d on true, copy paste to new location repeat for false false
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks