How do I connect two worksheets together?
I'm trying to connect two worksheets together whereas the input into a cell
of one will influence the outcome in the cell of another.
EX: Inputting 300 in a cell of the first sheet will give me an answer in a
cell of the second sheet, less 15%.
Is this at all possible? The sheets are in the same workbook. and the value
of one must impact the second.
Many thanks for any information.
Regards,
Robert
|