VBA - Copy past to the last row

[mariab9]

Hi,

I'm having problems to find the right "language" to set this in VBA:

I want to copy and paste from one range to the last one with data. The number of ranges will change every day as there will be more or less data.

In the image attached, I want to copy Range("c2) to the last one, which is "c16" in this case. How can I do it in VBA.

I tried end(xldown) but it paste it until the last existing range in C, which contains blank cells and I don't want that.

Can someone help me, please?

 

[gordsky]

Hi,

I'm having problems to find the right "language" to set this in VBA:

I want to copy and paste from one range to the last one with data. The number of ranges will change every day as there will be more or less data.

In the image attached, I want to copy Range("c2) to the last one, which is "c16" in this case. How can I do it in VBA.

I tried end(xldown) but it paste it until the last existing range in C, which contains blank cells and I don't want that.

Can someone help me, please?

where are you wanting to paste the information?

 

[gordsky]

range("C2:C" & range("C" & Rows.count).End(xlUp).Row).copy

this will copy column "C" from C2 to the last row of data

 

[mariab9]

range("C2:C" & range("C" & Rows.count).End(xlUp).Row).copy

this will copy column "C" from C2 to the last row of data

Hi,
Thanks for your answer. However the formula you sent me just copy it. How would be the paste? I also only want to copy C2 and then paste to the last.

Wouldn't it be range("C2").copy range("C2:C" & range("C" & Rows.count).End(xlUp).Row) ?

 

[gordsky]

Hi,
Thanks for your answer. However the formula you sent me just copy it. How would be the paste? I also only want to copy C2 and then paste to the last.

Wouldn't it be range("C2").copy range("C2:C" & range("C" & Rows.count).End(xlUp).Row) ?

no if you want to paste range("C2") AFTER the last row in column "C" you would need to Lose the second "C" in the range and also +1 to the last row reference.
The code would be

range("C2").Copy range("C" & range("C" & Rows.count).End(xlUp).Row + 1)

 

[mariab9]

Hi,

I want to paste C2 to C3 and all the rows that come after that, having into account that everyday C row numbers change.

I am not looking to paste it after the last row. I want to paste from C2 till the last raw with data. Would then be the same?

 

[gordsky]

Hi,

I want to paste C2 to C3 and all the rows that come after that, having into account that everyday C row numbers change.

I am not looking to paste it after the last row. I want to paste from C2 till the last raw with data. Would then be the same?

That’s slightly different to your original request. I think what your asking for is to take the value of c2 and paste it to the last row with data (value would need to come from the neighbouring columns as c2 is the last row with data in column c). If so you have two options

range("C2:C" & range("B" & Rows.count).End(xlUp).Row).FillDown

range("C2").Copy range("C3:C" & range("B" & Rows.count).End(xlUp).Row)

 

[mariab9]

That’s slightly different to your original request. I think what your asking for is to take the value of c2 and paste it to the last row with data (value would need to come from the neighbouring columns as c2 is the last row with data in column c). If so you have two options

range("C2:C" & range("B" & Rows.count).End(xlUp).Row).FillDown

range("C2").Copy range("C3:C" & range("B" & Rows.count).End(xlUp).Row)

Now it's working! :D

Many thanks

 

[gordsky]

Now it's working! :D

Many thanks

glad i could help, please mark as resolved (tick next to answer) if your query is complete