I am absolutely new to excel VBA.
I have a requirement to create an excel to maintain status of orders (there are about 6 / 7 order statuses (2 of which are OrderStatus(no status), Enquiry and taken as samples here ) and based on each status, a specific set of actions have to be performed. I have created the excel in which there are multiple columns & rows, some of the columns have data validations either from a reference sheet or entered as list in the Data validation part and some have formula references.
What little coding I could understand, I have done that based on my teeny weeny bit of knowledge + the ideas that I got from checking on various websites. As a result, I am not sure if I have a robust code, although, I have some piece of coding to perform certain actions based on values change in certain columns.
Following are the issues that I want help with:
When inserting / deleting row / rows, get error "Type Mismatch error 13"
The same error appears while certain columns are extended down to the cells.
Same error while cut copy pasting a row
Although the run time error occurs, the action is partially completed
Earliest response would be much appreciated.
My sample excel is attached