Filter/Delete.Rows then Copy New Data and Insert xldown

[exc4libur]

Helloooo, this is the solution guys..

This code:
- Arrays from Raw Data
- Filters/Deletes Rows according to criteria
- Copy Selection and Insert to sheet2

THANKS FOR THE HELP!

Please Login or Register  to view this content.

[stnkynts]

what is this?

Please Login or Register  to view this content.

It's usually a bad idea to use select/selection unless necessary. With that being said I have never seen so many select/selections crammed into such an area.

If you want to expand a range from your selection to the last row and column try something like this:

Please Login or Register  to view this content.

If you just want to copy "Sheet1" from D12 to column E and the last row then paste on sheet 2 use this:

Please Login or Register  to view this content.

Hope it helps.

[exc4libur]

Thank you sir!!!!!!