VBA/ Macros Help, organising rows based on one cells contents

[JM88]

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

[jmac1947]

a sample spreadsheet would be a great start please JM88
jmac

[JM88]

Hi Jmac1947,

Please see the attached spreadsheet. Let me know if it doesn't make sense and i will try to explain further. Thanks for the reply.