excelsldhs
New Member
- Joined
- May 10, 2022
- Messages
- 1
- Office Version
- 365
Hi,
I'm looking to create a macro that pastes the entire row (or I just need the first 11 columns) onto a new sheet based on cell criteria. The criteria I'm looking for is below and if any of them are true I'm hoping to copy the row over.
-if the age is under 19 or over 64 (column I)
-if column G is not blank
-if column J is not blank
-if column H equals "blue"
Any help with this is greatly appreciated! Thanks in advance.
I'm looking to create a macro that pastes the entire row (or I just need the first 11 columns) onto a new sheet based on cell criteria. The criteria I'm looking for is below and if any of them are true I'm hoping to copy the row over.
-if the age is under 19 or over 64 (column I)
-if column G is not blank
-if column J is not blank
-if column H equals "blue"
Any help with this is greatly appreciated! Thanks in advance.
