J
jkrons
I have a large Workbook, with a lot of sheets. In one of the sheets I
gather information from other sheets. In this sheet I like to use
goalseek on a certain formula, but as all the cells in this sheet are
formulas, the cant be used as cell to change, and apparantly you can't
use a cell in another sheet.
Can anybody suggest anything
Jan
gather information from other sheets. In this sheet I like to use
goalseek on a certain formula, but as all the cells in this sheet are
formulas, the cant be used as cell to change, and apparantly you can't
use a cell in another sheet.
Can anybody suggest anything
Jan