#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 698
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort data into order of product Jackmac Excel Discussion (Misc queries) 3 February 21st 06 03:09 PM
Sort data into order of product Jackmac Excel Worksheet Functions 2 February 21st 06 03:08 PM
Format excel sheet where one row is silver and the next white ??? nach New Users to Excel 5 December 16th 04 09:46 PM


All times are GMT +1. The time now is 11:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"