REPOST: Copy only rows containing data, paste below data

[redhots4]

I posted this a few days ago and only got a few responses that didn't satisfy my needs, mostly because I think my post / question was unclear. Thanks to those who replied the first time around.

Here's are my questions:

(1.) What is the VB code to select only rows containing data? Start in row 2 and end in Row X where X is the last row containing data.

(2.) Once item 1 above is satisfied, I need to go to another sheet ("Data"), find the first blank row (below all existing data) and paste the data copied in step 1 starting in Col A.

Thanks in advance!

 

[texasalynn]

please continue in original post:
http://www.mrexcel.com/board2/viewtopic.php?t=231705

ask questions if you don't get the answer you require