Thread: Create a Macro which shows precedents

Dear All,

Firstly, thank you very much for any replies!

So, what I am trying to do is three things:

Firstly, create a box which will appear when clicking on a cell containing my next two requests:

Secondly, a macro to show precedents

Thirdly, a macro to take those precedents, and say that if it is from sheet 1, row 23-35, column C, then call it March XYZ, as well as showing the number that was in Sheet 1, 23C.

The macro to show precedents, is being used for:
Lets say I have a figure that has been derived from 5 other places, then I would like a macro which shows where those 5 other places were, but as opposed to just saying Sheet1 C23, to say that was sheet 1 (Gold), Column C (Jeff's bid), between rows 23 and 50, i.e. its in the range of inputs for the month of March, and so it would say that the precedent was Gold, Jeff, March £15 for example, and this and all of the other precedents from which the number was derived would then appear in a box when the cell was clicked on.

I would surmise that the Row 2 Column C Sheet 1 to be called XYZ would be an IF statement, however I do not really know how to code this, and I sadly have no idea how to do the precedents or make the click box....

I am asking because this seems to me to be hideously complex, (and maybe impossible ) but if someone could help me out, I would be inestimably grateful!

Thank you again for any and all replies,

Freddie

thanks for the quick reply!
That is sadly not useful in this case, as the excel worksheet spans multiple sheets and 700 rows per sheet, so I sadly cannot remember exactly which sections equate to each cell, which is why a renaming macro along with a hover box would be hugely helpful.
f

its not off sheet, i.e. they are all in the same .xls file, just in different tabs
f