kieah
Sep 8, 2010, 10:07 PM
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
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