| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Connecting from one Excel file to another, how do you display info
I want to make a single template type file in Excel and have information that
will go in it in another Excel file. I see where you make the connection to the other file but I cant figure out how you have that information display into the template file. How is this done? Also im not sure where to start with it but I basically want it to create a single page per record on the template. How would I do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Connecting from one Excel file to another, how do you display info
The easiest way to link between workbook is to open both workbooks, start
type the equal sign into a cell, and while still editing cell contents, switch to other workbook, and click on the cell you want to link to. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Greg" wrote: I want to make a single template type file in Excel and have information that will go in it in another Excel file. I see where you make the connection to the other file but I cant figure out how you have that information display into the template file. How is this done? Also im not sure where to start with it but I basically want it to create a single page per record on the template. How would I do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Connecting from one Excel file to another, how do you display
Wow, that IS a lot easier!! what Im wanting to have done in the end is print
1 record per sheet. Is there a way of doing that also using this method? The number of records will be changing over time also "Luke M" wrote: The easiest way to link between workbook is to open both workbooks, start type the equal sign into a cell, and while still editing cell contents, switch to other workbook, and click on the cell you want to link to. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Greg" wrote: I want to make a single template type file in Excel and have information that will go in it in another Excel file. I see where you make the connection to the other file but I cant figure out how you have that information display into the template file. How is this done? Also im not sure where to start with it but I basically want it to create a single page per record on the template. How would I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Connecting a Pivot Table to .Tab Data file ** Minimise the connexion setup hassle | Excel Discussion (Misc queries) | |||
| Can I enter info in Excel and have it display as an '*'? | Excel Discussion (Misc queries) | |||
| connecting two Excel workbooks so one grabs info from antoher? | Excel Worksheet Functions | |||
| Reflecting info between an excel file and a word one or two excel file. | Excel Worksheet Functions | |||
| Reflecting info between an excel file and a word one or two excel file. | Links and Linking in Excel | |||
Hybrid Mode
