Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel File in Use Notification Missing?? | Excel Discussion (Misc queries) | |||
Unable to open excel sheet in Protected mode from VB 6.0 | Setting up and Configuration of Excel | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Reports in Excel | Excel Discussion (Misc queries) |