Deleting rows from sheet 1 when table on sheet 2 does not have the data anymore

Hi, I really hope someone can help me out this time round. 3rd time posting and hoping someone out there can solve my problem.

Currently, Im running a button macro. When this button is clicked, the table from "315 Employee Data" will copy the names from column C to "315" sheet B12 onwards.

Now, what i want is when I update the employee data on "315 employee data" sheet, I want "315" sheet to automatically match the names from "315 employee data", delete and add names when I add or remove employees from the column the next time i click on that button again.

After the above is achieved, when i add new employees,run the macro and it displays the updated list of names, I want "315" sheet column A to do automatic numbering.

I have attached the file for your reference.samplesample.xlsm

Any kind soul out there that can help me fix this?!?!?!! Dying here. Please help..

Charmaine

Hi Charmaine
I have made some minor changes to your button Macro and updated the formulas in column A so you get automatic numbering up to row 150. You will need to change the links to your source data then I think you will be there.
Hope this helps.
Good luck.
Tony

Dear Tony,

The macro works like a miracle!!!! Thank you so much for helping me out. I almost wanted to give up already!

Thank you for spending time on this. I appreciate it a whole lot.

Regards,
Charmaine