MS Excel wizz's Is there a script for?

[mike31154]

Been a while since I've done any playing around with Excel and I'm using an older version, but you might be able to use the "Insert Hyperlink" function to do what you need. I've got a modified sheet I found somewhere on the web which does an age calculation for your water to track water changes. I used this feature to link data from a cell on one sheet to another where I also had water change related data.

Not sure what version of Excel you have, but the feature I used is under the "Insert" menu. Simply choose "Insert Hyperlink" and this will open a small window with numerous options. On the left of this window should be a choice for "Place in This Document". Once you choose that icon, you should then see a cell reference option to the right. That will allow you to find and choose the cell on whichever sheet in the document you wish to display in the cell on the main sheet you're working on. HTH.