Hi,
I started putting this one together but it became too complicated for me as I have two conditions...
On sheet "Sheet 1" if the cell in column I contains "L" then copy that row to sheet "LH" and then cycle through all the next rows until complete.
But also,
On sheet "Sheet 1" if the cell in column I contains "R" then copy that row to sheet "RH" and then cycle through all the next rows until complete.
I could do the one condition, but not two.
Thanks for any help!
I started putting this one together but it became too complicated for me as I have two conditions...
On sheet "Sheet 1" if the cell in column I contains "L" then copy that row to sheet "LH" and then cycle through all the next rows until complete.
But also,
On sheet "Sheet 1" if the cell in column I contains "R" then copy that row to sheet "RH" and then cycle through all the next rows until complete.
I could do the one condition, but not two.
Thanks for any help!