I would like to create a pop-up window by clicking on one cell while working
on one sheet which will cause a window to open which displays a range of
cells which are located on another sheet in the same workbook and I would
like to be able to access the cells in that window. A very simple example
would be to access a range of cells that simply =A1*B1*C1=D1 where the
formula is in cell D1 and I can enter the data in cells A1, B1, and C1 in the
pop-up window. The function of the range of cells accessed through the
pop-up would be more complex than the simple example given. I just want to
be able to access the range of cells and make use of all of their functions
via the pop-up window.

Hopefully, this is possible and someone knows how. Thank you for your help.