gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,342
- Office Version
- 365
- Platform
- Windows
I have a table "Task_List" where the user will enter an X in column B if they want to use the data from that applicable row
How do I look down column B and where there is an X, copy the value in column Y and Paste it to tab "PBoMTaskList" (or sheet15) starting in B11 - looping through column B to find each time there is an X
Thank you for the help.
How do I look down column B and where there is an X, copy the value in column Y and Paste it to tab "PBoMTaskList" (or sheet15) starting in B11 - looping through column B to find each time there is an X
Thank you for the help.
Code:
Sub PBOMTASKLISTID()
Dim lrow As Long
lrow = Sheet14.Range("Task_List").Columns(3).Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
End Sub