Thread: Referencing and using data already calculated

here is the book i have done so far see if you get what i mean.

Book2.xlsx

noone knows?? is it even possible?

bump for no response.

im thinking that this maynot be possilbe, maybe a macro or progam would be better?

See the INT function, and use it to calc whole lengths, then multiply the result by the length reqd, then subtract from stock.

i already have the sheet doing that. if you look at column H,J,I it automaticly works out the length from 1 stock bar (typical r)emainder (or non typical remanders)

or are you saying somthing else?

what i need it to do is to take that remaining length and check it against the other stock lengths required and then use that instead of a full stock length

I have updated the sheet now will also show if the length cannot be cut from the stock length and will show if the remainder is under 150

but still no luck getting it to reference it. it would have be bee somthing like

check row "X" for number greater than Check row "Y" then use number "Y" instead of "Z"

but in a continual for so it would check for longest lentgh then second then third etc

i have attached the latest version to look at also. have a play see if you can figure it out.

Book2.xlsx

bump again. should I let this die or does someone know.

am I not clear or is it just not possible?

still holding out for hope