User form Data Entry Help VBA

My question I guess is how do I take this information verify the data, find duplicate entries, replace or overwrite, count rows, insert information without overwriting information

i.e.

Coloumn 1
Asset Name Asset Class Description Location Customer State Asset No. Comments Employee: Serial No.
10 HP HS Pump Equipment ********* ******** Wyoming 25373 Me



Userform 1

Please Login or Register  to view this content.

Userform 2

Please Login or Register  to view this content.

Any help or suggestions is greatly appreciated

Please use code tags around your code.
Click the edit button to edit your post, then select all of your code and click the # icon on the tool bar and save changes.

You code will go from looking like this:
Sub Test()
End Sub

To this:

Please Login or Register  to view this content.