How to hyperlink a single cell in an excel sheet with another cell in another excel/ ppt ,etc document.
For eg: On clicking the link the system has to display Cell A51 of Cash sheet of Financials workbook only.
Eg: Row
Coloumn A B C
1 =A1*B1
2
3
How to prevent user from entering value in C1 and display a msg asking them to enter values in A1 and B1 to get result?