link to sheets
 

I have one summary sheet which contains a link to the same cell on multiple
other sheets (image a quotation with individual sheets per machine, and one
general summary pricing sheet).
At times, I need to change the sequence of my individual sheets to better
reflect the content.
Is there a way to automically update the summary sheet to reflect this
change of sequence in worksheets?

link to sheets
 

Try the code example on this page to get a new sheet with links when you want it
http://www.rondebruin.nl/summary.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"rob" wrote in message ...
I have one summary sheet which contains a link to the same cell on multiple
other sheets (image a quotation with individual sheets per machine, and one
general summary pricing sheet).
At times, I need to change the sequence of my individual sheets to better
reflect the content.
Is there a way to automically update the summary sheet to reflect this
change of sequence in worksheets?

link to sheets
 

Ron, this worked out fine. Thanks for the tip

"Ron de Bruin" wrote:

Try the code example on this page to get a new sheet with links when you want it
http://www.rondebruin.nl/summary.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"rob" wrote in message ...
I have one summary sheet which contains a link to the same cell on multiple
other sheets (image a quotation with individual sheets per machine, and one
general summary pricing sheet).
At times, I need to change the sequence of my individual sheets to better
reflect the content.
Is there a way to automically update the summary sheet to reflect this
change of sequence in worksheets?