Deleting data with VBA

[krlmlt89]

Hi

I need to create a code with VBA which does the following:

A user form will prompt the user to enter a serial number. The code will then search all the worksheets within a work book for this serial number. If found, all data in the row containing that number (i.e.. adjacent to that number) must be deleted. Also, all data below it must be shifted up one row to take its place.

Any idea how to do this please?

[:) Sixthsense :)]

I can provide you code but you have to create a userform with textbox and commandbutton, is this deal ok?

[krlmlt89]

Yes sure...shall I send you the excel sheet?

[:) Sixthsense :)]

Yes attach here please...

[krlmlt89]

See attachment

[:) Sixthsense :)]

What to do if multiple matches are found?

[krlmlt89]

delete all matches

[AB33]

Try this code. It deletes the entire row if it finds the series number entered by the user.

Please Login or Register  to view this content.

[AB33]

Try this code. It deletes the entire row if it finds the series number entered by the user.

Please Login or Register  to view this content.