| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i create link between two sheets | New Users to Excel | |||
| How do i link w/sheets to increase value without just overwriting | Excel Worksheet Functions | |||
| How to Link 2 Sheets with different formats | Excel Worksheet Functions | |||
| how can I link entire sheets? | Excel Worksheet Functions | |||
| Link 2 sheets | Excel Worksheet Functions | |||
Linear Mode
