To do this properly in Excel, you'd have to write VBA to perform a bunch of tasks that any decent Access database can do without VBA, or at least much more efficiently with VBA.
Samples are usually available right on your PC if you did a complete install of Microsoft Access. Just choose to create a new database from the "Access database, wizards, and projects".
Do yourself a favor before you do anything else. Write yourself specifications. Think about what main pieces of information you'll be tracking, such as:
I want to make some type of form , chart or database that will automatically create a cost sheet from unique part numbers. Let me explain. Customer orders a part number but that part number is made up of smaller individual part numbers jammed into one long string. Ex. J345 may be a basic TV and cost $100, C45 may be the color red and may cost $16, M16 may be external speakers and cost $87. The customer orders J345C45M16 and his cost is $203. This info (and description) prints on the front (or first sheet) but also there is a second sheet for internal use that actually tabulates company costs. Which program should I start with - Access, Excel, ??? I would like to stay with Office 2000 software. Any samples out there I could download or view? I appreciate your help.