Grocery list

[Simphiwe Zondi]

Hi,
I want to create a grocery budget spread sheet, but I don't know
where to start. My idea is to create a grocery data base which I have
done by capturing all my monthly grocery slips on to a spread sheet,
I have a column for the Items and one for the prices, but now I'm
Stuck. The plan was to be able to tick each Item required that month
and this will calculate the total amount and print out the list of
items required that particular month. please help I'm really
stuck....do I use Excel VB, Macros or just formulas?

 

[Sam Wilson]

I'd use just plain formulas.

Say Column A you have the items, and Column B the prices. In column C I'd
then put the quantity (not just a tick - you might want 2 of something) and
then in column D I'd have the formula =B2*C2 to get the total price.

Then use Autofilter, and don't show 0s in column D to get the printable
version.

Sam