Delete Columns with Macros

Hi,

I have created an Excel Spreadsheet with Macros that will "Add New Person" for tracking qualification purposes (in the "Ph 1 & Ph 2" tab AND "Ph 3 & Ph 4" tab). However, I am trying to figure out a way to delete a person if they ever leave the team. I know that I could just select the columns and delete that way, but I was really wanting a way to just click a button to "delete team member" or something like that. I would want to delete the 5 columns that reference that person (columns G:K for "Ph 1 & Ph 2" tab and columns F:J for "Ph 3 & Ph 4" tab). This macros would need to reference the person directly below it...

for example, if I add a new person (columns L:P for "Ph 1 & Ph 2" tab), then I would want a way to delete those specific columns.

Not sure if this is possible. I have attached the spreadsheet for reference.


Thanks!

Hi,

Thank you for the quick response but that didn't seem to work for me