Help a silver Surfer
Hi, I sell trailers and need to produce quotations. There are six different types in a group. i.e Powder=SSK60, SSK65, SS70 and so on. With each tank there are options ie number of hatches possible answer 1to 6, axle type possible answer saf or bpw, and so on Is it simple or beyond the scope of a new starter? Regards |
Help a silver Surfer
Hi Trailerman,
To be honest, I'm not sure what you are trying to do. Doug -- Douglas Ryan VanBenthuysen Office System Solutions Specialist 3Sharp http://blogs.3sharp.com/Blog/dougv/ "trailerman" wrote: Hi, I sell trailers and need to produce quotations. There are six different types in a group. i.e Powder=SSK60, SSK65, SS70 and so on. With each tank there are options ie number of hatches possible answer 1to 6, axle type possible answer saf or bpw, and so on Is it simple or beyond the scope of a new starter? Regards |
Help a silver Surfer
My husband does something very similar to this on a *much* larger basis. As
in hundreds of thousands of cells. I don't think it's all that easy. Are all of your options available on all of your units? If so, it's easier. If not, you're probably in over your head. I can check with him after work, if you'd like. -- JoAnn Paules MVP Publisher "trailerman" wrote: Hi, I sell trailers and need to produce quotations. There are six different types in a group. i.e Powder=SSK60, SSK65, SS70 and so on. With each tank there are options ie number of hatches possible answer 1to 6, axle type possible answer saf or bpw, and so on Is it simple or beyond the scope of a new starter? Regards |
Help a silver Surfer
Perhaps a combination of Data Validation drop downs and Vlookup. Where the
drop down offer the various selections of options and the vlookup produces the price for that option. HTH Regards, Howard "trailerman" wrote in message ps.com... Hi, I sell trailers and need to produce quotations. There are six different types in a group. i.e Powder=SSK60, SSK65, SS70 and so on. With each tank there are options ie number of hatches possible answer 1to 6, axle type possible answer saf or bpw, and so on Is it simple or beyond the scope of a new starter? Regards |
All times are GMT +1. The time now is 02:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com