Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grocery list
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grocery list
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 "Simphiwe Zondi" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a grocery budget that includes cost? | Excel Discussion (Misc queries) | |||
How do I set up a grocery coupon database | New Users to Excel | |||
a weekly grocery list and costs, available coupons and value | Excel Worksheet Functions | |||
I need a running total of monthly grocery expense | Excel Discussion (Misc queries) | |||
Excel template to compare grocery prices at two or more stores | Setting up and Configuration of Excel |