Create new workbooks from template based on sheet with data

Jelmer · #5 03-12-2019, 02:14 AM

Thank you very much, NoSparks! Now it stops when it's out of visible rows

However, the data for Flname is a hyperlink in the Data sheet and should also be a hyperlink when the template is saved as new workbook. Is this possible?

I tried

Code:

Dim Flname As Hyperlink

but that didn't work, unfortunately.

EDIT:
To be more clear, the hyperlink shows as 1234-5678 but links to for example google.com/1234-5678. The cell in the template should still read 1234-5678 but the link should be still the same. This is important as the filename is based on the contents of this cell.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy data from one sheet to another based on a certain criteria	shina67	Excel Programming	2	12-28-2016 07:32 AM
Mailmerge create a coloured box based on data	haydencohen	Mail Merge	1	11-25-2015 03:32 PM
Create custom quote based on template	torma156	Word	3	09-06-2015 11:04 AM
Create a Bar with a slider that move based on data	jgallet	Excel	8	08-21-2015 03:41 PM
How to create a data validation based on another cell's value??	cfreezy	Excel	1	06-18-2015 09:51 AM