[SOLVED] Automatically Input Range of Numbers and Return Output

**wonderfulle** · 07-26-2010, 02:05 PM

So I have created a pretty intricate spreadsheet that takes one input number and returns 20 or so values drawn from other spreadsheets or calculated using the input.

Is there a way to automatically input a list of numbers I have and return 4 of the output values? (Or just one output if that's easier?)

Thanks!

**StephenR** · 07-26-2010, 02:36 PM

Yes, but I suggest you attach a sample workbook as not entirely clear what needs doing.

**wonderfulle** · 07-26-2010, 02:51 PM

Here's a sample. On Sheet 1, you can input numbers under "Input" and the spreadsheet will calculate three numbers - A, B, and C.

On Sheet 2 is a list of inputs. Basically, I want to fill in A, B, and C on Sheet 2 by entering the input number on Sheet 1 and returning the values calculated on Sheet 1.

On the actual spreadsheet, the calculations are much more involved so values must be returned from Sheet 1 and formulas cannot be copied over onto Sheet 2.

Thanks!

**StephenR** · 07-26-2010, 03:01 PM

This does what you want, but I don't think you need sheet1 at all.

Please Login or Register  to view this content.

**wonderfulle** · 07-26-2010, 05:02 PM

Originally Posted by StephenR

This does what you want, but I don't think you need sheet1 at all.

Please Login or Register  to view this content.

Sorry - had to run out to lunch. Just tested it. Works perfectly! Thank you!

[SOLVED] Automatically Input Range of Numbers and Return Output

LinkBack

Thread Tools

Rate This Thread

Display

[SOLVED] Automatically Input Range of Numbers and Return Output

Re: Automatically Input Range of Numbers and Return Output

Re: Automatically Input Range of Numbers and Return Output

Re: Automatically Input Range of Numbers and Return Output

Re: Automatically Input Range of Numbers and Return Output

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions