Find then Delete rows from multiple sheets?

**gronnies** · 11-19-2010, 03:37 PM

Hello!

I need a way to locate a code (ie: AV8032) in several separate excel worksheets and then delete the entire row from each of them.

For example it would find and delete this row (not the headers of course):

Item Description ID Link Color Weight
Shoes Brand X AV8032 www.abc.com Black 1.09

The headers in each file are different (ID may be SKU in another file)

Also I DON'T want it to delete something like TAV8032 or AV80329.

Thanks in advance!

**Leith Ross** · 11-19-2010, 04:36 PM

Hello gronnies,

Can you clarify these contradicting statements...

I need a way to locate a code (ie: AV8032) in several separate excel worksheets and then delete the entire row from each of them.

Also I DON'T want it to delete something like TAV8032 or AV80329.

**gronnies** · 11-19-2010, 04:53 PM

Oh sorry - I meant that I want to be sure it only deletes the cell that says AV8032 exactly - nothing before or after it.

**stnkynts** · 11-19-2010, 05:00 PM

Hello groonies,

I think you mean that you want to delete the whole row which contains AV8032 exactly. Also, It will need to be done on different sheets where AV8032 can be located in many different rows and columns. If this is true then this code should work for you. TRY ON A COPY OF YOUR WORKBOOK.

Please Login or Register  to view this content.

Let me know if it works. Also in the future you may want to look at posting your questions on a different forum. The napoleon complex of the moderators around here is quite appaling. They are way more concerned about you following all 150 of their rules to the "T" rather than helping those in need. Either way let me know if it helps. Oh btw moderator can i please get another infraction for helping someone?