Forum Discussion
Excel sheet as a calculator for import and export
I'm wondering if there is a way to have Excel take an input value from one sheet, put that value into the calculation sheet and then have the calculation sheet produce an output value onto the first ...
Is there an example of the calculation somewhere?
The answer would appear to be 'Yes, this is basic functionality of Excel' but I suspect there is a catch somewhere! One point, though, concerning the way in which the problem is stated: "is there is a way to have Excel take an input value from one sheet, put that value into the calculation sheet ". Excel never takes a value from one place and puts it somewhere else; that would require procedural code such as VBA. Using Excel worksheet formulas, one builds a formula at the end point that references the calculation that, in turn, references the input.