Hello I am a new user to the forum and I am hoping that through this network I can meet people who will be able to help me in a rather large undertaking. I will start by giving you a general idea of what I am attempting to do with excel, and then go into further detail later about specific problems that I am encountering.

I have been working for a small but rapidly growing manufacturing company for about a year now. Presently, we have no automation and/or file sharing within our departments which creates a paperwork nightmare (not to mention is horribly inefficient).

Currently we have several departments which each have pieced together small excel spreadsheets to accomplish and record their individual goals. For example, sales uses an excel template to take orders. Our production scheduler uses excel to create schedules for both production and engineering. Purchasing uses several small files to help in that arena. And shipping uses excel files to record what has been shipped.

I am trying to created a robust model that will achieve the following objectives.

-First, increase overall efficiency but eliminating redundant data entry.

-Second, improve overall management effectiveness by allowing changes to be viewed by all users of the system simultaneously (or within a matter of a few minutes).

-Finally, create a single database system that stores all of the relevant information for each job.

Also, since I would like each user to be able to edit only particular ranges I am not sure whether it would be best to do this using a shared file on a network location or a web based file.

I have given this a lot of thought over that last few months and have a really clear picture of how I would like to put this together into a useful system. The only problem is I do not know any programming language. My hope is to be able to achieve this goal using only VBA, but I am hearing that this may not be the best option.

Since we are a manufacturer we have "stock" items that we make routinely and unique items as well that are made to customer specifications. That being said, I will start with sales.

--Sales--
Customer Contact Information (Name, Phone, Email, Address, etc.)
Order Information (Model/Size/Finish/Graphics)
Additional Parts/Add-ons (Keychains, Seatposts, TShirts, etc.)
Expected Ship Date

Once information is entered into the sales form I would like the system to be able to recognize whether we have the item in stock or if we need to build the item and then respond appropriately. If the item(s) are in stock then the system should designate one of the stock items for the sales order. If the item(s) are not in stock then the system should put them on a list of things to be built.

--Accounting--
Be able to click a check box when money has been received on the order

--Scheduling--
Be able to see what items are currently in stock and which items need to be built.

--Production--
Be able to enter jobs that have started production and then check off progress as the item moves through each workcenter towards completion.

--Shipping--
Be able to see all items that are coming into the department and then have the system identify order that have all constituent parts complete and ready for shipment so that this department only spends time preparing orders for shipment which are completely ready to go. Then be able to click a box that the order is in fact completed and shipped and enter a tracking number.

Your thoughts on the best way to go about this would be greatly appreciated.