ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   stock control system (https://www.excelbanter.com/charts-charting-excel/34876-stock-control-system.html)

martin

stock control system
 
trying to see up a 'basic stock control sytem' for a warehouse that contains
building materials.
--
Thank you.

fanaya


You can use multiple ways of doing, there's 3 ways to come to my
head...

1) Use a worksheet as database an save all the information on the cells
of that worksheet using some macros to access it and handle.

2) You might want to use Access instead of Excel, I think would be
easier to handle the database portion and you still have the Macros
available.

3) You can use VB with an Access to create an application.


--
fanaya
------------------------------------------------------------------------
fanaya's Profile: http://www.excelforum.com/member.php...o&userid=25203
View this thread: http://www.excelforum.com/showthread...hreadid=386459



All times are GMT +1. The time now is 08:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com