Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generate Pricelist from Product list in Excel 2003
Hello, I don't know if this belongs here, or in the functions or programming
sections, so I'll start here. My company produces Excel pricelists for every product we sell. The pricelists group the products by class, and include prices for 3 different currencies in 4 different organizations. The product list looks like this: CLASS SKU PRODUCT UPC Org1 Org2 Org3 Org4 Class1 SKU1 Prod1 UPC1 P1 P2 P3 P4 Class1 SKU2 Prod2 UPC1 P1 P2 P3 P4 Class2 SKU3 Prod3 UPC3 P1 P2 P3 P4 etc. Price list looks like this: Class1 SKU1 Prod1 UPC1 P1 P2 P3 P4 SKU2 Prod2 UPC2 P1 P2 P3 P4 Class2 SKU3 Prod3 UPC3 P1 P2 P3 P4 etc. Currently I have to set up the Class headers (which can change), then copy and paste the rows for the products under the headers. If a product gets added or dropped in the product list, I have manually add or delete the rows in the pricelist. We have 10 pricelists, 5 with 10 tabs, 5 with 1 tab, for the various currencies we deal with. This is a very manual, labor intensive process, and prone to error. I want to automate the process, but, unfortunately, MS Access is not a possibility. My question: is there a way, using formulas or vb, to extract the classes as headers, and the products as data in the format above. I'm basically taking the left column of the product list and using it to create group headers on the pricelist. I would like the pricelist to automatically adjust to any changes in the product list. A long post, I know, but any suggestions will be greatly appreciated! Thanks, Bernie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Vista get Aero and product key box | Excel Discussion (Misc queries) | |||
using a result of a formula to generate text in Excel 2003 | Excel Worksheet Functions | |||
how to generate data from a list on excel from another worksheet? | Excel Worksheet Functions | |||
How to generate a worksheet out of an Excel 2003 database? | Excel Worksheet Functions | |||
How to generate a report from multiple lists in Excel 2003? | Excel Discussion (Misc queries) |