Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ideas needed please
Hello all, and thanks for your help!
I am trying to create a spreadsheet to track sales from my BakeShop. BakeShop sells to 50 different schools, and has 18 inventory items. My first task, i think, is to enter sales from August of this year to now. This data is no hand written sheets, aprox. 200 of them. I'm think data form, maybe?? thanks!! PS. Here at my new job they think I'm a genious thanks to your help on my previous project! -- Jeff |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ideas needed please
Jeff,
Whatever you do, use a database - either in Excel or not. If you use Excel, use only one sheet, with all the data fields that you need: school, item, date, amount, price, etc. That will allow you to use filters to look at individual schools or items, and pivot tables to summarize your data. HTH, Bernie MS Excel MVP "Jeff" wrote in message ... Hello all, and thanks for your help! I am trying to create a spreadsheet to track sales from my BakeShop. BakeShop sells to 50 different schools, and has 18 inventory items. My first task, i think, is to enter sales from August of this year to now. This data is no hand written sheets, aprox. 200 of them. I'm think data form, maybe?? thanks!! PS. Here at my new job they think I'm a genious thanks to your help on my previous project! -- Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ideas needed, pls help.. | Excel Worksheet Functions | |||
Anyone else have any ideas?? | Excel Discussion (Misc queries) | |||
Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...) | Excel Discussion (Misc queries) | |||
Any Ideas? | Excel Worksheet Functions | |||
Any Ideas | Excel Discussion (Misc queries) |