Hi all,
I need a sort of model on excel where I can manage customers and their orders.
Each sheet will be a customer and there will be a three main sections – “Add Order”, “View existing orders” and “View Completed orders”.
Add order
When I want to add a new order, I created a macro to open up the cells that hold the data fields for the new order.
Once the data has been filled in, When I click “Save & Close”, the data should move to the end of the “View existing orders” list, the data fields in “Add order should be cleared and should be hidden again.
If “Save & Add Another” is clicked then the same thing as above needs to happen except that it should not hide the cells.
View existing orders
Only the first 7 cells (from A to G) should be updated when a new order is received. Column H is a formula and the rest of the columns will be updated manually.
In column N (completed), I’m not sure how this is going to work, but I want to be able to click something and then have the data transferred to the end of the list of completed orders.
Once done with the Viewing, when I click “Click”, the cells should hide again.[ATTACH=CONFIG]40159[/ATTACH]
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!