| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert a pop-up window showing line information? | Excel Worksheet Functions | |||
| Document Information Panel In Excel 2007 | Excel Discussion (Misc queries) | |||
| Cells showing unwanted information... | Excel Discussion (Misc queries) | |||
| Default Information Showing Up | Excel Worksheet Functions | |||
| How do I merge excel information with a word document? | New Users to Excel | |||
Linear Mode
