Hi,
As part of my code, I need the following:
1. In Workbook Test Sheet under Sheet 1, if column B of the row contains a comma, it will be copied to Workbook Test Sheet2 under Alex. If there is no comma, it will be copied to Workbook Test Sheet2 under IMD
2. This needs to be done in a loop from row 2 to the last row. ( I am able to figure this out)
Thank you in advance for your help!
WB Attachment
As part of my code, I need the following:
1. In Workbook Test Sheet under Sheet 1, if column B of the row contains a comma, it will be copied to Workbook Test Sheet2 under Alex. If there is no comma, it will be copied to Workbook Test Sheet2 under IMD
2. This needs to be done in a loop from row 2 to the last row. ( I am able to figure this out)
Thank you in advance for your help!
WB Attachment