can i copy a hyperlink with absolute and relative references

=?Utf-8?B?anVuZS5zaWR3ZWxs?=

Guest

Posts: n/a

27th Dec 2006

i want to make a row of cells on sheet 1 hyperlink to sheet 2 with an
absolute column reference and a relative row reference,can i do this in one
cell and copy it down the row somehow or do i have to create(or edit) the
hyperlink in each row?

« Protection to add a line to Remove "Select Locked Cells" ??? | How to refer to an other worksheet (or book) »

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
absolute & relative references	zzulu4	Microsoft Excel Misc	2	1st Apr 2009 05:54 PM
Help with converting a block of cells with Absolute and mixed references to relative references	Vulcan	Microsoft Excel Worksheet Functions	3	13th Dec 2007 11:43 PM
Absolute / Relative References	=?Utf-8?B?VGltIE1pbGxz?=	Microsoft Excel Programming	2	25th Jul 2005 12:32 PM
Check relative / absolute references	oli	Microsoft Excel Programming	1	5th Jul 2005 01:22 PM
Relative & Absolute References	Don Dennis	Microsoft Excel Worksheet Functions	3	1st Aug 2004 03:21 AM