![]() |
Excel as a database
is there any possibility that i used to print a invoice through excel for my
product sale. is there any way excel can generate monthly sales book as a database. Please show me any path Thanks in advance. Rao Ratan Singh |
Rao,
Consider Access for this project. To do this properly, you'll likely need a table for your products (your inventory or product line), one for your invoices, one for the items in your invoices, and if you're keeping customer information, one for your customers. Excel is terrific, but a lot of darn work to implement related tables, move records around, etc., as your business flows. Access may be harder to learn, but the payoff is well worth it. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Rao Ratan Singh" wrote in message ... is there any possibility that i used to print a invoice through excel for my product sale. is there any way excel can generate monthly sales book as a database. Please show me any path Thanks in advance. Rao Ratan Singh |
All times are GMT +1. The time now is 08:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com