Set your sheet up so you can filter on on a single column.
(Data=Filter=Autofilter). This might require using the next available
column and putting in formulas so it returns a filterable value when that
row should be printed.

--
Regards,
Tom Ogilvy

"Ness" wrote in message
...
Hi,

I have a spreadsheet which lists groceries under various subheadings over
several worksheets, where I can enter the number of each item required and
it
calculates the total cost (in each section and total). It's great for
working
to a budget, but too long to take shopping with me! Would anyone know how
to
setup a function so that only the items entered can be printed (with the
subheadings also if possible)? That way I could print off a small list
with
only the items needed, instead of the whole thing. Any ideas would be
appreciated, or tips on where to look for further information would be
great!
Many thanks in advance. Ness.