Can i take an entire row from one sheet and it will automatically input on another

holloway79

New Member
Joined
Jul 31, 2010
Messages
5
Need help on this! I can give a cell a name in the name box on sheet #1 and go into sheet #2 and do an =nameofthatcell and it will work. I'm wanting to find a way to copy an entire row or part of a row to the other sheet without doing one cell at a time. Can I name a row or 2 or more cell and put that name in sheet 2?

Thanks
 

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.

PA HS Teacher

Well-known Member
Joined
Jul 17, 2004
Messages
2,838
If I understand you correctly, you do not need (in fact it is probably more difficult) to use a named range.

In A1 of Sheet 2 enter:
=Sheet1!A1

Copy A1 of Sheet 2 and paste where desired. The relative reference will change accordingly.
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
Note, you can also just do a straight copy off of sheet 1, then hop over to sheet 2 and do a Paste Special and pick Paste Links.
 

Watch MrExcel Video

Forum statistics

Threads
1,133,575
Messages
5,659,616
Members
418,514
Latest member
radonwilson

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top