I have 2 issues firstly I have a cell A1 that returns the current date this is fine. I have a list of dates from the start to the end of the year and I need to return the cell reference that the equivlent date is in. (dates in cells A2 to A366.
I then need to create a chart using a changing cell the problem I have with this is that as soon as I select a cell as the source data it uses that cell and not the reference in it. I.E B1=Sheet1!$D$6:$I$17 but when I select this as source data the graph just shows B1 and not the reference in it.
Hope this is clear.
All help appreciated
I then need to create a chart using a changing cell the problem I have with this is that as soon as I select a cell as the source data it uses that cell and not the reference in it. I.E B1=Sheet1!$D$6:$I$17 but when I select this as source data the graph just shows B1 and not the reference in it.
Hope this is clear.
All help appreciated