ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Where do I start (https://www.excelbanter.com/new-users-excel/27131-where-do-i-start.html)

Curt

Where do I start
 
I have to create a PC order form for customers to order new PC equipment. I
have only done simple excel spreadsheets. What I am looking to do is once a
customer chooses say a Latitude D810; all the options for that particular
laptop will appear. Any help will be appreciated.
--
Thanks

Bill Ridgeway

I have thought of doing something similar. Even on a limited range of
hardware there are a number of possibilities and permutations. Added to
that is the fact that product ranges and prices are continually changing
giving yet further possibilities and permutations. I came to the conclusion
that it was not worth continually updating the database. Instead I opted for
a basic comprehensive check list of components (by type). This needs to be
updated only when, for instance DVD drives began to be required. The list
ensures that all possible components are considered when working up a
costing. (It is better to decide that something is not wanted than to
overlook it and find out later). Individual quotes are made with reference
to this list and the detail (40Gb HDD, 80Gb HDD etc) and price added as
required. If you are in the UK don't forget to include VAT in the final
price!

This approach may not be useful, however, if you have a large volume of a
small range of products but you'll have to take a view on that!

Regards.

Bill Ridgeway
Computer Solutions

"Curt" wrote in message
...
I have to create a PC order form for customers to order new PC equipment.
I
have only done simple excel spreadsheets. What I am looking to do is once
a
customer chooses say a Latitude D810; all the options for that particular
laptop will appear. Any help will be appreciated.
--
Thanks





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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com