copying data in a non-contiguous column

hi, i just need a way to copy non-contiguous data from a column, but based on the number of rows in another column that has contiguous data in it. in the example below i want to copy all the 5 (number of entries in col A) data points in col b including the blanks.


A B
a text 1
b
c text 2
d
e

not sure if you mean that col B should match col A or you want col A to copy to a different column?

thoughts

eventually all the data in col B will get copied to a different location, but for now I just need the command/steps to copy all of the data in col B (down to the last row in col A). I was using the code below but that only goes down to the end of data, which in this case would be "text 2", not down to the final blank across from where the "e" is in col A.

Please Login or Register  to view this content.

You can try

Please Login or Register  to view this content.

thanks fluff13. that does work but i was just using that as an example. my actual data has the contiguous data in col "D" and the copying non-contiguous data in col "AT." when i modify the columns in your statement it gives me everything in between also. don't know if there's a way to copy just col "AT" in my actual data based off the rows in col "D."

Try

Please Login or Register  to view this content.

Thanks. Even though the offset is hard coded, that does work. however, now when I try to paste that data somewhere else on the sheet, i get an "Run-time error 1004 PasteSpecial method of Range class failed." I am using the statement below. Any idea why I am getting that error?

Please Login or Register  to view this content.

Is the selection the same size as the range copied?

in my actual data col AT has 25 rows but only 4 entries with the rest being intermittent blanks. i want to copy all the 25 entries over to another spot. if i do it manually it works.

thx. but the number of rows is based off of the total number of rows in cold D, so it's only 25 for now but it can change. the destination range cell won't always be in the same spot but where the cursor ends up.

How do you determine where to paste the data?

@Fluff13, it actually goes into a separate workbook into a template that looks like the original data but is blank waiting for the new data to to be pasted there.

Maybe

Please Login or Register  to view this content.

@fluff13, thanks. that kind fo works but i was able to take some of your earlier stuff and make it work, so it works now. thanks for your help.

You're welcome & thanks for the feedback