transfer column data from 1 sheet to another

[ornatum]

Hello friends,
Please someone help!

I enter some numbers in column F on sheet1. These numbers must be transfered to column B in sheet2. I then delete the numbers on sheet1 and enter some new numbers in the same column(F). What I want is that, after entering the new numbers on sheet 1, these numbers must be transfered to sheet2 column B, below the previous numbers, delete numbers on sheet1,transfered to sheet2, below previous numbers,etc.etc

[Logit]

.
Using this code, paste into a routine module and activate with a command button. See attach:

Please Login or Register  to view this content.

[ornatum]

thank you Logit. I will try it!!!!!!!!!!

[ornatum]

Hi Logit. thank you again, its working!!!

Can you please help again. Just to make it a little complicated!

After transfering the numbers in column B on sheet2, I want them to stop at row 16, and the rest of the numbers to be transfered at column C/sheet 2, up to row 16 again and if I have more numbers, to be tranfered at column D/sheet2, etc..etc.

Thanking you in advance

[Logit]

.

Please Login or Register  to view this content.

[ornatum]

Thank you again Logit.

You are gr8!!!!!

[Logit]

You're welcome. Glad to help.