Hi,
I would appreciate your help with the following.
I want to copy and paste lines in Sheet1 which have a value in column B to a new worksheet (Sheet2), appending them on the first blank line.
Data to be copied if condition is met......Column A, B & C for each row where B is not NULL
Paste into Sheet2, on the first blank line (A into A, B into B and C into C)
In my example rows 2 and 5 would copy (Apple and Orange)
Thanks in advance.
Bookmarks