RattlingCarp3048
Board Regular
- Joined
- Jan 12, 2022
- Messages
- 172
- Office Version
- 365
- Platform
- Windows
You all have been so helpful in learning VBA so I am back again!
I need a code that basically says if Column T >/= 10 on Sheet 1, move the entire row to next available row on Sheet 2.
Headers are in Row 1 and are exactly the same on both sheets.
Value in Column T is formula based (=IF(S2-R2<0,"",S2-R2)).
I tried to record myself but couldn't quite figure out how to manipulate it to move the entire row.
I need a code that basically says if Column T >/= 10 on Sheet 1, move the entire row to next available row on Sheet 2.
Headers are in Row 1 and are exactly the same on both sheets.
Value in Column T is formula based (=IF(S2-R2<0,"",S2-R2)).
I tried to record myself but couldn't quite figure out how to manipulate it to move the entire row.