Best Way to

[Joanne]

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

 

[Guest]

Hi

It sounds like a big task
If you want to email me the spread sheet I can play with it for you

Steps :
Probbaly make a form for the user
with command buttons for each options you decribed

(e-mail address removed) or msn messenger

Thanks