Linking 3 workbooks sheets to master workbook template
How can open my master template workbook and have the information from 3
separate workbook sheets load into my master workbook.
I have three Reports that I poll everyday with Crystal Reports. These 3
reports are then exported into excel as 3 separate workbook sheets.
I now have them linked to my master template workbook with special paste
links.
Problem is that I have to have all 4 books open for the information to
update in master book.
I need it to just automatically link the information or copy the sheets over
to mastertemplate daily.
How can this be achieved? The needs to be a simplier way to do this. To
had to try my staff. Too many different reports to work with.
"jacob" wrote:
How do you link a cell to another cell in a different workbook?
for example:
Book1 Sheet1 cell A1 to Book2 Sheet2 cell A2
|