Connecting from one Excel file to another, how do you display info

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you print 1 record at a time per page? 5
Does Excel file retain link to template? 1
Startup Template - Excel 2007/Vista 7
add the macros contained inside a template to an Excel file. 1
How do i transfer information from one excel file to another excel 1
Excel Template 13
Excel How to Fix Damaged Excel File That Won't Open? 3
How to Export datas from Excel cells to another excel/dbase file 2

Back
Top