Hi,
My name is Dan. I am an expert in excel and userform design and coding. I have done a very similar project recently which included the features you have explained. Through this User Interaction form, you can completely manage the datasheet.
I need a little clarification with the Sequence rows and row numbers. I see its currently formulated in your datasheet. So by retaining integrity of this data, do you mean to say, if a record is deleted, it must delete the sequence and row numbers alongwith it, while the rest of the records continue to retain the assigned Row and sequence number when it was initially entered. If so, I am thinking why not include it as part of the form.
Please message me so that we can discuss further and proceed. Thanks !
Regards
Dan