Grocery list

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?
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top