Help with using a work sheet to compile data

L

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!
 
L

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
 
G

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.
 
Top