Work Sheets with in different workbooks

pmarsch

New Member
Joined
Apr 7, 2011
Messages
2
I am working with two different workbooks and need to transfer certain sheets from one to the other. Is there a formula for this?:confused:
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

JazzSP8

Well-known Member
Joined
Sep 30, 2005
Messages
1,223
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
There isn't a formula to transfer a whole sheet however you can right click on the Sheet name which will bring up a menu, then you can select to 'Move or Copy' that sheet into the other workbook :)

(Just remember to select the 'Create a Copy' tickbox if you just want to copy it)

:)
 

pmarsch

New Member
Joined
Apr 7, 2011
Messages
2
Can a part of a worksheet from one workbook be transferred to another workbook sheet?
 

JazzSP8

Well-known Member
Joined
Sep 30, 2005
Messages
1,223
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
Depends on what your trying to do...

Copy and Paste will work for the most part, though if you trying to bring the formulas across as well then you might run into trouble somewhere along the line.

You can also always just link directly to the cells by starting off with an equals sign as normal and then clicking on a starting cell in the other workbook; this is likely to give you an absoloute reference, the cell reference will include $ signs which you will need to remove before you can drag it like you would a normal formula.

Just experiement a little and then see what happens when you want to move stuff around, if you run into trouble then just post back with what your troubles are and then can help you out a little better, your questions are a little broad at the moment.

:)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,719
Messages
5,597,733
Members
414,170
Latest member
Mdm

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