Showing information from an excel document to another excel docume

  • Thread starter Thread starter Patboy
  • Start date Start date
P

Patboy

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?
 
Maybe..........

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

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

Vaya con Dios,
Chuck, CABGx3
 
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 said:
Maybe..........

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

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

Vaya con Dios,
Chuck, CABGx3



Patboy said:
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?
Click to expand...
Click to expand...
 
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 said:
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 said:
Maybe..........

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

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

Vaya con Dios,
Chuck, CABGx3



Patboy said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top