Find lastrow and delete rows

tableq,

This macro accomplishes what you described. It uses a loop (which I don't really recommend, but its much easier to follow for beginners than autofilter code) and can easily be adapted to fit your requirements. I commented the code as much as possible in order to explain what was going on.

Please Login or Register  to view this content.

EDIT: Good catch on those, WasWodge, code has been updated with the corrections.

(=code(RC[-208])) which is supposed to be the code of column B

I think the offset needs to be -211 and not -208 to get column B from Column HE

I think there also needs to be 1 less bracket in tigeravatar's code i.e.

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thank you both so much! That worked really well!

If i wanted to copy data from the report sheet to a sheet called NORMDataSheet, and I wanted it to capture all the data from row 2 until the last row, could I use the syntax:

Please Login or Register  to view this content.

Right now I have all my code in the format

Please Login or Register  to view this content.

simply due to the fact that I was unsure of how to make everything go through the last row. So if i change all of it to:

Please Login or Register  to view this content.

for example, will this work throughout my code?

If I was doing it then I would probably use something like the code below and then just use MYRNG throughout the code.

Please Login or Register  to view this content.