Record results into another worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2361647%22%20slang%3D%22en-US%22%3ERecord%20results%20into%20another%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2361647%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20created%20a%20calculator%20in%20excel%20for%20cost%20estimation%20purposes%20and%20I%20want%20to%20record%20the%20results%20into%20a%20table%20in%20another%20worksheet.%20I%20am%20not%20sure%20how%20to%20move%20the%20results%20into%20the%20table%20and%20continue%20adding%20newer%20ones%20into%20new%20rows.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2361647%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2361666%22%20slang%3D%22en-US%22%3ERe%3A%20Record%20results%20into%20another%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2361666%22%20slang%3D%22en-US%22%3Ewhat%20you%20are%20asking%20would%20require%20a%20macro%20but%20i%20wouldn't%20recommend%20that.%20What%20does%20your%20%22calculator%22%20do%3F%20How%20many%20inputs%20does%20it%20require%3F%20i%20ask%20because%20I%20would%20recommend%20you%20just%20incorporate%20that%20%22calculator%22%20into%20the%20table%20so%20that%20the%201st%20column%20or%202%20(depending%20on%20how%20many%20inputs%20your%20calculator%20needs)%20would%20be%20those%20inputs%20and%20then%20the%20formula%20in%20the%20next%20column%20uses%20your%20%22calculator%22%20function(s)%20to%20get%20the%20result.%20This%20has%20the%20added%20bonus%20of%20keeping%2Frecording%20all%20the%20original%20data%20which%20means%20if%20you%20have%20a%20problem%20later%20you%20can%20go%20back%20and%20find%20that%20data%20entry%20error%20you%20made%20and%20correct%20it.%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello, I created a calculator in excel for cost estimation purposes and I want to record the results into a table in another worksheet. I am not sure how to move the results into the table and continue adding newer ones into new rows.

1 Reply
what you are asking would require a macro but i wouldn't recommend that. What does your "calculator" do? How many inputs does it require? i ask because I would recommend you just incorporate that "calculator" into the table so that the 1st column or 2 (depending on how many inputs your calculator needs) would be those inputs and then the formula in the next column uses your "calculator" function(s) to get the result. This has the added bonus of keeping/recording all the original data which means if you have a problem later you can go back and find that data entry error you made and correct it.