Work Sheets with in different workbooks

[pmarsch]

I am working with two different workbooks and need to transfer certain sheets from one to the other. Is there a formula for this?

 

[JazzSP8]

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]

Can a part of a worksheet from one workbook be transferred to another workbook sheet?

 

[JazzSP8]

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.