create a form for inventory control

%3CLINGO-SUB%20id%3D%22lingo-sub-2023026%22%20slang%3D%22en-US%22%3Ecreate%20a%20form%20for%20inventory%20control%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2023026%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%20i%20am%20very%20new%20to%20Excel%20or%20VBA.%20Recently%20i%20am%20planning%20on%20a%20start%20up%20which%20i%20need%20an%20inventory%20control.%20I%20would%20need%20inserts%20few%20things%20into%20the%20forms%20and%20get%20it%20sort%20and%20track%20on%20real%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20create%20code%20and%20names%20based%20on%20image%20uploaded%3C%2FP%3E%3CP%3E2.%20stock%20in%20%2F%20out%20based%20on%20code%20%2F%20name%20or%20image%3C%2FP%3E%3CP%3E3.%20current%20stock%20status%20for%20each%20item%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20enlighten%20me%20or%20share%20your%20thought.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2023026%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2023465%22%20slang%3D%22en-US%22%3ERe%3A%20create%20a%20form%20for%20inventory%20control%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2023465%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F914489%22%20target%3D%22_blank%22%3E%40Zhen_Kits%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20off%2C%20welcome%20to%20the%20Excel%20Community.%20Since%20you%20mentioned%20you%20are%20new%20to%20Excel%2C%20an%20important%20process%20in%20designing%20a%20workflow%20and%20translating%20it%20to%20Excel%20is%20understanding%20what%20%3CA%20href%3D%22https%3A%2F%2Fwww.pcworld.com%2Farticle%2F3234335%2Fexcel-databases-creating-relational-tables.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Erelational%20database%3C%2FA%3E%20is.%26nbsp%3BUnderstanding%20how%20Unique%20IDs%20are%20created%20and%20referenced%20between%20tables%2Fsheets%2Fworkbooks%20will%20help%20you%20better%20structure%20your%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFollowing%20up%20on%20your%20questions%2C%20excel%20isn't%20the%20best%20software%20for%20storing%20%22images%22%2C%20while%20creating%20a%20code%20or%20name%20structure%20is%20something%20that%20is%20premeditated%20and%20calculated%20in%20your%20spreadsheet%20based%20on%20your%20own%20set%20of%20parameters.%20Also%2C%20%22%3CSPAN%3Estock%20in%20%2F%20out%20based%20on%20code%20%2F%20%3CSTRONG%3Ename%20or%20image%3C%2FSTRONG%3E%22%20should%20be%20rephrased%20to%20a%20single%20unit%20of%20reference%20(always%20being%20the%20name%2Fnumber).%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20a%20current%20workbook%20with%20no%20confidential%20data%20that%20you%20can%20send%20over%2C%20that%20will%20provide%20better%20pointers%20for%20others%20to%20help%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi guys, i am very new to Excel or VBA. Recently i am planning on a start up which i need an inventory control. I would need inserts few things into the forms and get it sort and track on real time.

 

1. create code and names based on image uploaded

2. stock in / out based on code / name or image

3. current stock status for each item

 

please enlighten me or share your thought. 

1 Reply

@Zhen_Kits 

First off, welcome to the Excel Community. Since you mentioned you are new to Excel, an important process in designing a workflow and translating it to Excel is understanding what relational database is. Understanding how Unique IDs are created and referenced between tables/sheets/workbooks will help you better structure your data.

 

Following up on your questions, excel isn't the best software for storing "images", while creating a code or name structure is something that is premeditated and calculated in your spreadsheet based on your own set of parameters. Also, "stock in / out based on code / name or image" should be rephrased to a single unit of reference (always being the name/number).

 

If you have a current workbook with no confidential data that you can send over, that will provide better pointers for others to help you.