autocreating hyperlinks in excel? ie 500 cells to 500 hyperlinks?

=?Utf-8?B?dGVycnk=?=

Guest

Posts: n/a

1st Nov 2007

Ive set up a spreadsheet, that acts as a database. I have an index list of
qoutes that hyperlink to the actual spreadsheet quote. But each time i need
to create a new qoute I need to manually assign (hyperlink) one of these
quotes to the index. Is there anyway to do this automatically?

thanks

« VLOOKUP with 2 criteria | Why my workbook suddenly open slower than before? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Update 2000 Excel hyperlinks to 2003 hyperlinks	=?Utf-8?B?bG9udjE1NQ==?=	Microsoft Excel Worksheet Functions	4	25th Oct 2007 05:51 AM
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up !	=?Utf-8?B?amFjb2I3MzU=?=	Microsoft Excel Misc	1	22nd Jun 2007 12:57 AM
Hyperlinks between two cells and referntially copying hyperlinks	Chris Swinney	Microsoft Excel Discussion	0	6th Mar 2007 09:44 AM
Excel Hyperlinks- cell content v. hyperlinks	=?Utf-8?B?aGVycGV0YWZhdW5h?=	Microsoft Excel Misc	2	23rd May 2006 04:39 AM
Why is sort of hyperlinks in Excel hardcoded to cells?	=?Utf-8?B?bnAzNzI1?=	Microsoft Excel Crashes	0	4th Nov 2004 04:54 PM