Hi All,

Happy New year. I had some brilliant assistance from this forum with a problem i had mid last year around VBA coding and a database that i have developed using Excel.

The coding seems to have changed an no longer works. Is any one able to help me please? I am still a novice when it comes to VBA coding. I can attach a sample of the database here for everyone to see if that would help.

Simply i would like the coding to allow me to move a row from one sheet to another based on a value in a column (in this case based on their qualification "coach", "referee", "Presenter" )

In addition to this i have a code that allows me to click a button and will then save the sheet as a separate workbook which allows me to send it with out sending the entire document. However i would like this button to lock the sheet at the same time when it saves. Is this possible?

Any help would be greatly appreciated.

Kind regards

JM88