gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,342
- Office Version
- 365
- Platform
- Windows
I have a table and in the last column (F) there will be a Yes, No or it will be blank.
I want to loop through each row of the table (which starts on row 4) and if that row has a "Yes" in column F, I wan to copy that rows cells A, B, C, D and E
Past it in the next available Row in columns B, C, D, E and F
That tabs Name is CMOPUpload
The Table that its looping through is on a tab named ItemIDList (table name is ModelGeneral_vluItem)
Also on CMOPUpload it should start looking in Row 11 down for the next blank row to paste it in.
Any Help is very much appreciated, as always!
I want to loop through each row of the table (which starts on row 4) and if that row has a "Yes" in column F, I wan to copy that rows cells A, B, C, D and E
Past it in the next available Row in columns B, C, D, E and F
That tabs Name is CMOPUpload
The Table that its looping through is on a tab named ItemIDList (table name is ModelGeneral_vluItem)
Also on CMOPUpload it should start looking in Row 11 down for the next blank row to paste it in.
Any Help is very much appreciated, as always!