Help with my excel spreadsheet

[Guest]

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.

 

[Tom Ogilvy]

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.