I made a range that is called Batch1, which includes a break down of
information.
THere are two things that I want to do.
1) I want to be able to simply type in 'Batch1' into a cell and have it
automatically link to that range, same goes for a possible 'Batch2,
batch3,ect..'
2)I want that link to pop-up as a text box containing the infortation in the
range Batch1. I do not wnat it to be a hyperlink, but i would like it to,
when its selected, pop-up the window with a further breakdown of inforation.

If you have any suggestions or ideas, let me know. my work email is


Thank you.