Bring one sheet from one workbook to another via formula
 

Hi there.

Is there a way to bring Sheet 1 from File A in to Sheet 1 in File B without
utilizing the move or copy function and without writing a formula for each
cell you want to bring in?

Strange question, I know.

Bring one sheet from one workbook to another via formula
 

Check out Ron de Bruin's site for code.

http://www.rondebruin.nl/copy7.htm


Gord Dibben MS Excel MVP

On Tue, 28 Nov 2006 12:02:03 -0800, Fgbdrum
wrote:

Hi there.

Is there a way to bring Sheet 1 from File A in to Sheet 1 in File B without
utilizing the move or copy function and without writing a formula for each
cell you want to bring in?

Strange question, I know.