I do not know VBA yet I've been asked by my commanding officer to create this file from scratch. I've been trying to learn but I could really use a lot of help! Please see attachment.
I have a master sheet that lists people and info about each person. Each person has his/her own sheet that lists the same info from the master list. The list will be updated regularly and I need each individual sheets to update based on the master sheet.
The sheet "Cadets" is the list of names. My macro currently can detect new names and copy the information from columns A:I about that person to a new sheet with that person's name. I still need it to be able to detect changes to existing names and update the info as well as detect deleted names and delete the corresponding sheet.
Columns J:BP are possible attributes each person could have indicated by an 'x' in the column. I need the macro to detect an x and put the appropriate attribute into a list on that person's page. These lists also need to update with changes.
The sheet "delta, charlie" is an example of what a person's page should look like. The titles in cells A5, D5, I5, and A12 could all be created when a new sheet is created, but I don't know how to do that. The various lists from possible attributes will populate under those titles. The lists with the word "Additional" in the title will be updated manually for each person.