Hi All,
I am trying to get my head around macros. Basically I have a table where I have drop down lists, once a dropdown is changed to 'Completed' or 'Stock Received' (Column B) I want the row to move to the bottom of the active table automatically on changing to the dropdown.
I've tried a few different codes in VBA that I have found, I have updated Trust Centre Settings to enable macros. Yet when I try to save the file it tells me "the following features cannot be saved in macro-free workbooks. Choose a macro-enabled file type in the file type list"....
So I am actually not sure if it is my code or a macro issue.
Any help would be greatly appreciated! I am new to this, yet learning on the go!
Many Thanks All
I am trying to get my head around macros. Basically I have a table where I have drop down lists, once a dropdown is changed to 'Completed' or 'Stock Received' (Column B) I want the row to move to the bottom of the active table automatically on changing to the dropdown.
I've tried a few different codes in VBA that I have found, I have updated Trust Centre Settings to enable macros. Yet when I try to save the file it tells me "the following features cannot be saved in macro-free workbooks. Choose a macro-enabled file type in the file type list"....
So I am actually not sure if it is my code or a macro issue.
Any help would be greatly appreciated! I am new to this, yet learning on the go!
Many Thanks All