Moving cells to blank cells

Hello all. I am wondering if its possible to move 2 adjacent cells say from Column A and B on sheet 2 to sheet 1 column A and B. It needs to search through A and B on sheet 1 to find the 1st to empty adjacent cells and use those together. Hope that makes sense and thanks for any help

Assuming row 1 on sheet 2:

Please Login or Register  to view this content.

So i am trying to combine it with another macro which finds a certain value in column B and moves it and the adjacent text in column A from sheet 2 to sheet 1 then clears the cells in sheet 2 and looks for the next value. Including the code with yours in which i tried to combine them.

Please Login or Register  to view this content.

Who knows. You usually can't just combine two separate codes together and expect them to magically work. If you submit a copy of your workbook with a detailed description of your entire process we could give you a direct answer. Here is a shot in the dark:

Please Login or Register  to view this content.