Find blank cell, then paste entire row onto another sheet

Hey everyone,

I have a few simple commands done, but I'm very new to VBA.

I have Column "J" and Column "L". Column "L" has sheet names on each row.

I want to do this:

1.) Find the first non-blank cell in Column "J"
2.) Copy the entire row of the non-blank cell.
3.) Paste the entire row onto another sheet.
4.) The sheet is named in Column "L" (Could be different for each row)


Appreciate any help in advance!

this code will do what you want, however your post seems to indicate that you only want to copy and paste the row with the first non-blank cell in Column "J", you don't want to copy all rows with non-blank cells in column "J"? if so the code should be changed to account for that

HTML Code: 

this code will copy all of the non blank lines to their respective sheets determined in the L Column

HTML Code: 

you could add this to the first macro so it won't just paste it in the first row, it will actually look to see if there is data in the first row, and if there is then it will paste it in the first blank row after all the used rows, you could use a loop to search for the first non blank row, but were getting pretty advanced then

HTML Code: