Good Morning everyone. I know what I am about to ask has probably been asked a million times over, but I wanted to ask in a way that pertains to my situation. I hope you all understand. I have created a tracking system for my wife who is starting a small business from home. I am trying to make it as simple to use for her so she can make sure everything she is doing is being properly tracked. Below is a list of questions that I am trying to get help with. I am trying to create macros for these situations so that the tracking system is pretty self-sufficient. But to be honest, I am not savvy with writing macros in VBA, so I am reaching out for some help. I will gladly answer any questions you have to make it easier for everyone that is willing to help. I really appreciate any help that can be provided. Please see the below questions.
1. Move completed orders to completed orders tab when box is checked in column E. Remove that row from current orders tab and move all current orders up. Do not copy New Orders button to completed orders tab
2. Have new orders button auto populate next sequential number and fill in date received based on when button is pushed, while keeping all the same formatting at previous cells
3. Have date auto fill on completed orders tab when current order is complete (date complete button is clicked) and moved to completed orders tab (column G)
4. Have inventory be deducted based on completed order (I.e. we have 20 boxes, one order completed, now there are 19 boxes) while being able to add to inventory number without messing up previous orders
5. Be able to un-check complete box and have it move back to current orders tab in case something happens with that order. And put it back in sequential order.
1. Move completed orders to completed orders tab when box is checked in column E. Remove that row from current orders tab and move all current orders up. Do not copy New Orders button to completed orders tab
2. Have new orders button auto populate next sequential number and fill in date received based on when button is pushed, while keeping all the same formatting at previous cells
3. Have date auto fill on completed orders tab when current order is complete (date complete button is clicked) and moved to completed orders tab (column G)
4. Have inventory be deducted based on completed order (I.e. we have 20 boxes, one order completed, now there are 19 boxes) while being able to add to inventory number without messing up previous orders
5. Be able to un-check complete box and have it move back to current orders tab in case something happens with that order. And put it back in sequential order.