reports from excel

[Lynda]

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

[MartinShort]

Very easy to do this by using AutoFilters on the view menu.

If I was doing it, I would do the following.

1. Set up a filtered view (Data->Filter->AutoFilter) ie custom and does not equal zero.
2. Now define 2 custom views (View->Custom Views) as "All" and "NotZero".
3. Record a macro that switches on the view and goes to the print preview screen
4. Record a second macro that switches to view all.
5. Lastly, set up a couple of buttons (Use the Forms Toolbar) on your sheet and assign the two macros to them.

If you do all of this, it will be a no brainer for your managers. These steps are not particularly difficult but will take a little working through on your part.

MS

[Nick]

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" <Lynda@discussions.microsoft.com> wrote in message
news:819D08E5-F04F-4B7F-9FBA-90451D4D55CB@microsoft.com...
>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

[MartinShort]

Nick raises a good point.

I would strongly suggest that Excel should NEVER EVER have any blank data in a "table". It causes so many problems. The rule is fix the data format and don't try to work around the problem. From your question though, you seemed to be talking about non zero values?

MS