Home

Excel sheet as a calculator for import and export

%3CLINGO-SUB%20id%3D%22lingo-sub-450142%22%20slang%3D%22en-US%22%3EExcel%20sheet%20as%20a%20calculator%20for%20import%20and%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-450142%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20wondering%20if%20there%20is%20a%20way%20to%20have%20Excel%20take%20an%20input%20value%20from%20one%20sheet%2C%20put%20that%20value%20into%20the%20calculation%20sheet%20and%20then%20have%20the%20calculation%20sheet%20produce%20an%20output%20value%20onto%20the%20first%20sheet%20for%20that%20input.%26nbsp%3B%3CSPAN%3EIn%20effect%20one%20table%20contains%20values%20to%20import%20to%20the%20calculation%20sheet%20and%20it%20reports%20the%20calculated%20values%20which%20were%20output%20by%20the%20calculation%20sheet.%20My%20calculation%20sheet%20is%20very%20complex%20but%20all%20I%20need%20it%20to%20do%20is%20input%20my%20values%2C%20run%20each%20one%20and%20spit%20out%20a%20result%20for%20each%20input%20value.%20I%20only%20have%20one%20input%20value%20and%20one%20output%20value%20for%20each%20size%20of%20cable.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-450142%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-450750%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20sheet%20as%20a%20calculator%20for%20import%20and%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-450750%22%20slang%3D%22en-US%22%3EGiven%20the%20complexity%20of%20your%20calculation%20sheet%2C%20you%20need%20to%20provide%20a%20simplified%20version%20thereof.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-450897%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20sheet%20as%20a%20calculator%20for%20import%20and%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-450897%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320682%22%20target%3D%22_blank%22%3E%40scampbell87%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20an%20example%20of%20the%20calculation%20somewhere%3F%3C%2FP%3E%3CP%3EThe%20answer%20would%20appear%20to%20be%20'Yes%2C%20this%20is%20basic%20functionality%20of%20Excel'%20but%20I%20suspect%20there%20is%20a%20catch%20somewhere!%26nbsp%3B%20One%20point%2C%20though%2C%20concerning%20the%20way%20in%20which%20the%20problem%20is%20stated%3A%26nbsp%3B%22%3CSPAN%3Eis%20there%20is%20a%20way%20to%20have%20Excel%20take%20an%20input%20value%20from%20one%20sheet%2C%20put%20that%20value%20into%20the%20calculation%20sheet%20%22.%26nbsp%3B%20Excel%20never%20takes%20a%20value%20from%20one%20place%20and%20puts%20it%20somewhere%20else%3B%20that%20would%20require%20procedural%20code%20such%20as%20VBA.%26nbsp%3B%20Using%20Excel%20worksheet%20formulas%2C%20one%20builds%20a%20formula%20at%20the%20end%20point%20that%20references%20the%20calculation%20that%2C%20in%20turn%2C%20references%20the%20input.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
scampbell87
Occasional Visitor

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 sheet for that input. In effect one table contains values to import to the calculation sheet and it reports the calculated values which were output by the calculation sheet. My calculation sheet is very complex but all I need it to do is input my values, run each one and spit out a result for each input value. I only have one input value and one output value for each size of cable.


Thanks

2 Replies
Given the complexity of your calculation sheet, you need to provide a simplified version thereof.

@scampbell87 

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.