populate horizontally after a column up to specific column lastrow

[Reggieneo]

Hi All,
how can i put values from last row in also a dynamic blank column?
please know that there are already values in the sheets.
kindly see sample attached.
in Row 3, Column C is the next blank cell so i need the data to fill them from C to G or whatever the column or data requires.

in row 4 , after i filled the row 3, the data needs to start from column B.

please assist.

kind regards,
reggieneo

 

[vletm]

Reggieneo
Where is Your data?
It would matter a lot ... or not!
If random data then ... how many rows?

 

[Reggieneo]

Reggieneo
Where is Your data?
It would matter a lot ... or not!
If random data then ... how many rows?

Hi vletm,
I was thinking just random but please see in Sheet2 now. the Sheet2 C2 must go to Sheet1 C3 and the Sheet2 B3 must go to Sheet1 B4. kindly remember that blank rows and column will be dynamic. blank row may start in other column next time.

thanks much.

 

[vletm]

Reggieneo
Excel do not ...
I cannot figure Your 'must' ... nor ... 'remember'.
I won't overwrite data if possible!
Press [ Do It ]

 

[Reggieneo]

thanks for the code. apologies for choice of words.
i was meaning to say that sometimes the destination starts in column C or D or E or wherever the last data was populated that is why I made a sample book that one goes to B and the other to C. the size (width) of data is dynamic hence it needs to find the next blank column to avoid blank.
sorry not a native English speaker but hope i made my intent is clear this time.
much thanks

 

[vletm]

Did that code work as You've tried to write?
If 'yes' then okay
Otherwise ... make more clear sample
... actually many samples
... what would You like to happen ...
= which data goes where and so on ...

 

[Reggieneo]

I thought I could figure it out by myself but still really a newbie. please see more sample and the final results I need in sheet 3 Row 5.

please assist to populate sheet3 C going to right from Sheet1 C2 to H2 Data, then whenever it ends please add to the next blank cell the Sheet2 B3 to H3 Data.

my columns grows from time to time so it needs to find the next empty cell horizontally. it always starts from Column C though.

thanks again

 

[vletm]

Reggieneo
It's good that even one would figure ... what?
I tried to ask many clear samples .. that 's' also means many (over 1...over 10).
Did I get?

Could You try to explain Your 'idea' to Your coworker... son... grandfather... mom ...
and after few of those would understand You ... try to write here.

I cannot figure Your idea,
I cannot read that from Your mind ...