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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies