Grocery list

  • Thread starter Thread starter Simphiwe Zondi
  • Start date Start date
S

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?
 
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
 
Back
Top