Hi narayan, looks sweet. i couldn't download it at all. It kept DL as a powerpoint file then i couldn't open it or check the formulas.
Could you briefly explain what you have done?
thanks
Dave
Thanks Dan_l, i checked out the link. i think i get what you mean and i can see how the flow works, similar to Narayan's idea. So essentially i'm setting up a Table that i refer to based on the "conditions" and units required?
Narayan, can you help with a visual or some links to get me...
Hi Dan_l and Narayan,
Thank you for your feedback, Narayan, your spot on with what i'm trying to achieve! My customers will call me 5 times a day with a variation to their first order and i spend my life glued to a calculator as some quotes can be very complicated and errors cost me my income...
Hey Dan,
This really is a simple sheet, but right now the best i can do. I only enter into the green cells. the bottom section that is green i have to do by calculator and add in and the "existing block" normally is a minus amount.
thanks
Dave...
Hi Friends,
I love the challenge of excel and i've had some help from "hui", but i'm still having problems.
What i'm trying to do is automate my work process resulting a better work flow. The challenge is a long list of variables.
Essentially quantities x Cost.
Some tables would look...