Product Components

[glenn]

I am doing a spreadsheet for the price break down of various products. On the
first page of the workbook is the components and the prices. On the next
pages are what makes each product and the costings. Many of the products have
various different parts and some are the same. When I want to change the
price of a component I am able to get the price changed automaticly on the
rest of the book. But when I sort the component list the prices all mix up on
the rest of the work book. How can I sort the Component list with out the
prices changing.

Does this make sense to some one.

 

[mscertified]

This is an Access forum not EXcel.

 

[John W. Vinson]

I am doing a spreadsheet for the price break down of various products. On the
first page of the workbook is the components and the prices. On the next
pages are what makes each product and the costings. Many of the products have
various different parts and some are the same. When I want to change the
price of a component I am able to get the price changed automaticly on the
rest of the book. But when I sort the component list the prices all mix up on
the rest of the work book. How can I sort the Component list with out the
prices changing.

Does this make sense to some one.

Are you working with Excel Spreadsheets? or with Access Tables (the subject of
this newsgroup)?

This sounds like an application more suitable for Access; you could have two
(or more) related tables, and sort the queries joining them appropriately.

If you're trying to do this in Excel, I'd suggest reposting your question in
an Excel newsgroup.

John W. Vinson [MVP]