elsuji
01-04-2020, 01:09 PM
Dear Team,
I created the userform for add and delete the name.
I created the code for add Trainer and Trainees name. When i click add button for Trainer, the name will save to Sheet "Data" column A & when i click add button for Trainees, the name will save to Sheet "Data" column B
If is click delete button for Trainer, the added name should display for select unwanted name and then the selected name (Cell) should delete only on column and cells up.
For example i want to delete "Kaliraj V" from list and this name in Data!A5. First i want to select this name from list and delete only the cell A5 and the bellow cell should come up.
Similarly same condition for Trainees name which is in column B
I attached sample file with this message for your reference.
Can any one kindly help me for solving this
I created the userform for add and delete the name.
I created the code for add Trainer and Trainees name. When i click add button for Trainer, the name will save to Sheet "Data" column A & when i click add button for Trainees, the name will save to Sheet "Data" column B
If is click delete button for Trainer, the added name should display for select unwanted name and then the selected name (Cell) should delete only on column and cells up.
For example i want to delete "Kaliraj V" from list and this name in Data!A5. First i want to select this name from list and delete only the cell A5 and the bellow cell should come up.
Similarly same condition for Trainees name which is in column B
I attached sample file with this message for your reference.
Can any one kindly help me for solving this