Copy column and paste into same sheet

[Rose0402]

I need to copy all rows that have data in Sheet 13 column H starting at R2 (to end of row) and paste into Column C row 4. I cannot figure out. Thanks in advance!

[stnkynts]

You want all the data from multiple cells in a single cell (C4)?

If so like this:

Please Login or Register  to view this content.

[Rose0402]

I made a typo - it is just column H I need to copy to C.

I need to copy all rows that have data in Sheet 13 column H starting at H2 (to end of row)
and paste into Column C row 4.

[Rose0402]

I do not see a sheet reference or a paste in your code.

[stnkynts]

I do not see a sheet reference for Column C row 4 in your post nor an answer to my first question.

Why would I need the word paste?