Automatically moving colums from one worksheet to another

Diana36

New Member
Joined
Jun 4, 2010
Messages
12
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!
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Diana36

New Member
Joined
Jun 4, 2010
Messages
12
i meant when i add data on sheet 1 i want it to automatically add on sheet 3,

thanks.
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
In Sheet3 A1 enter

=Sheet1!A1

and copy down as far as needed

In B1

=Sheet1!J1

and copy down.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,943
Messages
5,508,262
Members
408,672
Latest member
Kalyani714

This Week's Hot Topics

Top