I have a large sheet and a pivot table to view the data.
i'd like to ignore some lines, e.g any line with an invoice number against
it. this would only display the un-invoiced items on the pivot table. is this
possible.
Thank You in advance for any suggestions.
--
Browny