How to create a macro to perform specific functions on different sheets within a workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1611990%22%20slang%3D%22en-US%22%3EHow%20to%20create%20a%20macro%20to%20perform%20specific%20functions%20on%20different%20sheets%20within%20a%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1611990%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20create%20a%20special%20type%20of%20macro.%20It%20would%20need%20to%20be%20able%20to%20perform%20functions%20like%20adding%20to%20inventory%2C%20when%20something%20is%20purchased%2C%20and%20subtracting%20from%20inventory%2C%20when%20something%20is%20sold.%20I%20would%20also%20need%20to%20be%20able%20to%20have%20the%20sales%20added%20to%20an%20earnings%20tab%20while%20purchases%20would%20go%20to%20an%20expenses%20tab.%20If%20a%20product%20is%20added%2C%20I%20need%20to%20to%20populate%20in%20earnings%20and%20expenses%20on%20its%20own%20line.%20I'm%20almost%20positive%20I'm%20talking%20about%20more%20than%20one%20macro%20here%2C%20but%20I'm%20just%20needing%20guidance%20(or%20someone%20who%20is%20willing%20to%20write%20it%20for%20me...I'm%20good%20either%20way).%20This%20is%20being%20done%20for%20a%20small%20start%20up%20company.%20Any%20help%20you%20can%20offer%20is%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1611990%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMigration%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

I need to create a special type of macro. It would need to be able to perform functions like adding to inventory, when something is purchased, and subtracting from inventory, when something is sold. I would also need to be able to have the sales added to an earnings tab while purchases would go to an expenses tab. If a product is added, I need to to populate in earnings and expenses on its own line. I'm almost positive I'm talking about more than one macro here, but I'm just needing guidance (or someone who is willing to write it for me...I'm good either way). This is being done for a small start up company. Any help you can offer is greatly appreciated.

0 Replies