Help with using a work sheet to compile data

[lowspark]

This site was recommended to me by a friend and well here is my firs
post! OK the first sheet in my workbook is a simple spread sheet tha
the user inputs data into. based on the data the user inputs i have
hidden worksheet that compiles the data and based on the findings
result is given back to a field in the first worksheet. so far so goo
buy i need this hidden worksheet to clear out the data so that for eac
row of data it will compile just the data in that row. so fo
example... if row one looks like this
1,4,6,Yes
the hidden work sheet compiles 1+4(6)=25 is less then 50 so YES
then i would like to clear and start the process over for the next row
the formulas i am using is much more complicated then this but it i
the basic idea. thanks all and hope to help out around here some ho
some way!

 

[lowspark]

Can i use the lookup function for this?? as i read about it it sees to
only look at one cell at a time? I would like to have it look at the
last cell with in a column that has data input? thanks again for your
help
z

 

[Guest]

Hi
It's not clear from your post how the figures are added/multiplied to get
whichever result you require. I think the only option is probably a macro.

AndyB.

 

[lowspark]

the " hidden work sheet" will look up a value in a1 for value #1 and a6
for value #2 and a12 for value #3. With this data from the cells a set
of calculations produce a number that is associated to a result so then
i would like this result to be populated in cell a22. but each row is a
different day so then the cell range that is looked up by the "hidden
worksheet"changes to the row letter. i need to know how to have it
look in the row that has the latest data entered and go get that
information out of those 3 cells and then populate to last cell with
the result. I hope this is clear but at 7:30 am after a long weekend i
did my best. thanks for the help and would love to hear what you have to
think!
z