Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Kevin do you think that I can setup something like that in Excel?
Or is it too complicated? "Kevin B" wrote: If you do have Access there are a number of wizard driven databases that can be generated with little effort on your part. This includes the tables, forms and reports. That might be a jump start. Open Access and select New Database and then select Templates on my computer. Click the databases tab and select the Inventory Control database and follow the on-screen instructions. At some point you could import your existing inventory information into the database from Exel. Hope this helps. -- Kevin Backmann "Eric." wrote: Thanks for the reply Kevin, Yes I tried the download center but did not find what I was looking for,I tried different template but missing the one. I am about to do an annual inventory with a lot of different parts and I wish I can find a software (excel format 2003) that I will update time to time. With the option to reenter new stock to add to the old stock witout erasing the previous one. also with a reorder level and price per item and total prices.... I know that Access will do better but I know nothing about access, Do you have some clues??? Thank you in advance. Eric. "Kevin B" wrote: Have you tried the Microsoft Office Download Center. Click URL below... http://office.microsoft.com/en-us/te...s/default.aspx -- Kevin Backmann "Eric." wrote: trying to find an excel sheet to do an inventory control. (unit in stock, unit received, level to reorder, unit price. total price...) Thank you for your help Eric. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inventory Control | Excel Discussion (Misc queries) | |||
Excel used for inventory control | Excel Discussion (Misc queries) | |||
How can I set up an inventory control system on Excel? | Excel Discussion (Misc queries) | |||
inventory control in excel | Excel Discussion (Misc queries) | |||
Creating a Multiple Warehouse Inventory Spreadsheets | Charts and Charting in Excel |