VBA copying and pasting data always into the empty cell after the previously filled one

[Palucci]

Hello Guys !
Maybe it will be easier on an example than in the name of the topic. I have tables where I paste data every month using a macro. However, I would like it to automatically paste into blank spaces. For example, in this msc pasted into the T column in a month it automatically detected empty position in the U columns . Is it possible ?

wb.Sheets("analysis-tabele").Range("B21:B35").Copy
wbMe.Sheets("blank3").Range("T2").PasteSpecial Paste:=xlPasteValue

 

[Zot]

Do you mean every month to next empty column? Then try this
wbMe.Sheets("blank3").Cells(2, Columns.Count).End(xlToLeft).Offset(0, 1).PasteSpecial Paste:=xlPasteValue

 

[Palucci]

When im trying put this

wbMe.Sheets("analysis-tabele").Range("B68").Copy
wbMe.Sheets("blank36").Cells(2, Columns.Count).End(xlToLeft).Offset(0, 1).PasteSpecial Paste:=xlPasteValue

I getting error about "Subsrcipt out of range"
But I have a question, how to set a macro to make entries wbMe.Sheets("analysis-tabele").Range("B68").Copy in
T2 and so, for example, the next .Range("B69") position in T3 to the empty next place etc.

 

[Zot]

Your sheet name is correct blank36, not blank3?

 

[Palucci]

Your sheet name is correct blank36, not blank3?

My fault, it is 3 but we missed "s" wbMe.Sheets("blank3").Cells(2, Columns.Count).End(xlToLeft).Offset(0, 1).PasteSpecial Paste:=xlPasteValue that why i got error

 

[Zot]

When im trying put this

wbMe.Sheets("analysis-tabele").Range("B68").Copy
wbMe.Sheets("blank36").Cells(2, Columns.Count).End(xlToLeft).Offset(0, 1).PasteSpecial Paste:=xlPasteValue

I getting error about "Subsrcipt out of range"
But I have a question, how to set a macro to make entries wbMe.Sheets("analysis-tabele").Range("B68").Copy in
T2 and so, for example, the next .Range("B69") position in T3 to the empty next place etc.

You meant
B68 > T2
B69 > T3
B70 > T4

on same sheet. Maybe you can record macro how transpose is done?

 

[Palucci]

You meant
B68 > T2
B69 > T3
B70 > T4

on same sheet. Maybe you can record macro how transpose is done?

Excatly, but its done now all ok , thank you so much