Hi, I want to delete a data based on the ID.
Mainly, I want to delete any data by entering the ID in a userfom. I will just enter the desired ID and a button will press the excel will delete all the data according to that id and push rest lower range data (which are present below deleted row) to upward to fill the blank, which is created due to deletion.
Please find the attached sample file.
Thanks in advance.
Mainly, I want to delete any data by entering the ID in a userfom. I will just enter the desired ID and a button will press the excel will delete all the data according to that id and push rest lower range data (which are present below deleted row) to upward to fill the blank, which is created due to deletion.
Please find the attached sample file.
Thanks in advance.