Automatically moving colums from one worksheet to another

[Diana36]

Can anyone tell me how to automatically moved data from one sheet to another. Ex. I want data entered on Sheet 1, columns B and J to automatically populate on Sheet 3, columns A and B. Is there any formula?

Thanks!

 

[VoG]

automatically moved

What does that mean exactly? When a value is entered it is automatically moved then deleted from Sheet1?

 

[Diana36]

i meant when i add data on sheet 1 i want it to automatically add on sheet 3,

thanks.

 

[VoG]

In Sheet3 A1 enter

=Sheet1!A1

and copy down as far as needed

In B1

=Sheet1!J1

and copy down.

 

[Diana36]

Thank you so so much!