reports from excel
 

I have created a spreadsheet for our Contract Managers so that they can
produce a quotation by picking and choosing the itme they need from a list.
When it comes to printing I need to find a way of printing only the rows that
have a 'Selling' value greater than zero.
Alternatively, we were going to do the list on Access but I didn't know how
to create the formulas. Any ideas? Please keep your answers as simple as
possible!

Thanks

Lynda

You need to hide the rows that have no value.
If the items are in a list on a spreadsheet that has heading at the top
i.e.
Row 1 has headings
Row 2 onwards is the list

you can use the built in autofilter command to hide the rows with no values
then print the sheet.
Assuming the list is continous with no black rows or columsn then select a
single cell anywhere in the list. If you have blank rows or columns select
the list manually ensuring the header row is the top row.
Then select Data - Filter - Autofilter from the menu.
Then select the drop down arrow for the column that contains the values you
want to filter on. Select Custom and set the Criteria to Not Equal to
<blank

Hope this helps



"Lynda" wrote in message
...
I have created a spreadsheet for our Contract Managers so that they can
produce a quotation by picking and choosing the itme they need from a
list.
When it comes to printing I need to find a way of printing only the rows
that
have a 'Selling' value greater than zero.
Alternatively, we were going to do the list on Access but I didn't know
how
to create the formulas. Any ideas? Please keep your answers as simple as
possible!

Thanks

Lynda