Using Filters

M

MamaSherry

I am new to using filters & am trying to create a worksheet that will help my
salesmen create quotes for our customers. I'd like them to be able to pick
different equipment options with related prices and then have all options
totalled at the bottom of the spreadsheet.

Pkg # Description
Amount
111 Option 1
209,667
112 Option 2
224,693
123 Option 3
211,265

Pkg # Description
Amount
02 Option 1
10,948
08 Option 2
13,345

The worksheet needs to be printable in landscape mode.

Thanks for any and all help!
MS
 
M

Mark

Hi,
another option would be to use a userform. The sales
person could then access the item in a list that would,
when clicked, show the price and any instructions. If
okay, click the accept button to send to a quote sheet.

I can also set it up for landscape printing.

I can create it for you if you can send me sample sheets.
original data sent is under strict confidentiality.

I need to see the layout of the stock lists etc...

It will take a few days to set it up.

See my excel stuff at
http://www.geocities.com/excelmarksway



regards
Mark E. Philpot
 
Top