rickloudin
New Member
- Joined
- Apr 23, 2021
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
I am new to VBA coding, Want to know if you can copy and paste cells from cells in the row above the cells that meet a certain criteria.
For example A3 meets my criteria and I want to paste the Range B2:E2 into B3:E3. The next time the criteria appears maybe in A8 so I would paste B7:E7 to B8:E8 and so on.
Any help would be greatly appreciated. Thank you!
For example A3 meets my criteria and I want to paste the Range B2:E2 into B3:E3. The next time the criteria appears maybe in A8 so I would paste B7:E7 to B8:E8 and so on.
Any help would be greatly appreciated. Thank you!