Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Using WinXP 2003 SP2 and MSOffice2003 with all updates
I have a wb with 62 wss, 1 for each vendor (sheet name = vendor name) Each vendor ws has cols for ProdNo, ProdDesc, UOM and a few cols for pricing levels: ProdNo ProdDesc UOM USG OSI FORTRESS Level 1 Level 2 etc. I have a table listing our 450 customers, 1 customer per record Each record has CustName, CustStreet, CustCity, the vendors the customer uses and the price level col addrs CustName CustStreet CustCity USG Fortress Level2 What I envision doing: Open copy of the master workbook (I don't want anyone messing with the originial Master Price Sheet wb) Capture the record from my table Read my record to: Hide all wss that are not listed on the customer record On remaining worksheets, hide all columns that are not listed on the record Now the user can give the customer pricing info they and/or print out a pricing sheet that is custom fit to the customer. Then the whole thing will get closed and dumped until user needs to generate a new report. So far I am using a list box and alpha command buttons - click cmdA and listbox shows all "A" customers and user chooses a record (thru the generous help from Ron Coderre of these newsgoups). I am pretty new at Excel, I don't like doing things more than once, so I am hoping for advice on if this is the proper approach to such a project of if there is a better way to accomplish my task. Thanks to you all for your time and consideration of my project. Joanne |