Showing information from an excel document to another excel docume
 

Hi,

My question is, I have 2 excel documents (excel1.xls & excel2.xls for
example) is there a way to display information like a cell or a whole sheet
from excel1.xls to excel2.xls?

Showing information from an excel document to another excel docume
 

Maybe..........

='c:\my Documents\[Excel1.xls]Sheet1'!A1

Modify as necessary to fit your conditions......

Vaya con Dios,
Chuck, CABGx3



"Patboy" wrote:

Hi,

My question is, I have 2 excel documents (excel1.xls & excel2.xls for
example) is there a way to display information like a cell or a whole sheet
from excel1.xls to excel2.xls?

Showing information from an excel document to another excel do
 

Hi, thanks for your response, it's working for a cell.

is there a way to make it work for an entire sheet?

thanks

"CLR" wrote:

Maybe..........

='c:\my Documents\[Excel1.xls]Sheet1'!A1

Modify as necessary to fit your conditions......

Vaya con Dios,
Chuck, CABGx3



"Patboy" wrote:

Hi,

My question is, I have 2 excel documents (excel1.xls & excel2.xls for
example) is there a way to display information like a cell or a whole sheet
from excel1.xls to excel2.xls?

Showing information from an excel document to another excel do
 

Not that I know of, other than to just copy and paste it to cover the range
of interest...........

Of course one can use VBA to open the file and copy the sheet out to the
activebook

Vaya con Dios,
Chuck, CABGx3

"Patboy" wrote:

Hi, thanks for your response, it's working for a cell.

is there a way to make it work for an entire sheet?

thanks

"CLR" wrote:

Maybe..........

='c:\my Documents\[Excel1.xls]Sheet1'!A1

Modify as necessary to fit your conditions......

Vaya con Dios,
Chuck, CABGx3



"Patboy" wrote:

Hi,

My question is, I have 2 excel documents (excel1.xls & excel2.xls for
example) is there a way to display information like a cell or a whole sheet
from excel1.xls to excel2.xls?