Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Linking in Excel (https://www.askmehelpdesk.com/showthread.php?t=506048)

  • Sep 8, 2010, 10:07 PM
    kieah
    Linking in Excel
    I have searched through the questions and answers to excel linking and can't find exactly what I am looking for. So far it looks as if hyperlink function may be the way I need to go but it's not quite what I want.

    I have a large sheet of items with all their details, as well as the prices of various supermarkets. What I really want to be able to do is be able to click on a cell and be linked to a list of dates. I am trying to track when the specials occur. So my Coke item has the supermarket price of coke at say $1.00 and the special price at $.50. I would like to be able to click on the cell with the special price and see or get to a list of dates when this special was on. Hope that makes sense.

    At the moment the best I can come up with is hyperlinking from the special price cell to another sheet's cell and just listing the dates in that one cell. But as I collect a few dates I won't be able to read it so well. I was hoping to be able to put each date in a cell of it's own. Or even some other data in a cell with a date coloumn maybe? Can someone think of a neat way of collecting this info.

    Thank-you
  • Sep 9, 2010, 12:10 PM
    jakester

    Can you provide an example of what you have put together so far? Upload your spreadsheet if you can.
  • Sep 9, 2010, 12:13 PM
    ScottGem

    If you want the spreadsheet to display a list of dates in another sheet, then hyperlinking is the way to go. You can name the range so it doesn't matter how many cells in the range or just jump to the first cell in the range.
  • Oct 10, 2010, 02:02 AM
    kieah
    Comment on ScottGem's post
    I didn't realise you could hyperlink to a range of cells - I haven't tried it yet, but it seems like it would do exactly what I was after... Thank you very much!

  • All times are GMT -7. The time now is 11:42 AM.