ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   combining worksheets (https://www.excelbanter.com/excel-worksheet-functions/193348-combining-worksheets.html)

antony

combining worksheets
 
i have a workbook1.xls which is a general list of employees and a
workbook2.xlt which is a pattern file of the personal data of one employee.
i create a hyperlink between the employee's last name on workbook1 and the
homonym file( which was created from the .xlt ). Is there any way to avoid
creating hyperlinks when i create a new employee? something like pre-existing
hyperlinks in workbook1 that when you click them a new file from the .xlt is
created?


All times are GMT +1. The time now is 11:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com