Finding next blank row and pasting problem

What I’m trying to do here is to auto filter everything and then filter column 4 for “20”
Copy the filtered area to a “TR 53 Div” sheet and delete it from original “TR 53 Other” sheet.
Next step is to do similar thing by filtering for “50” and copying it, but my problem is pasting it to a “TR 53 Div” sheet that already contains info for “20” and what I need to do is to find the next blank row in “TR 53 Div” sheet and paste “50”.

So, the bottom line is that I need a formula that will find the next blank row in “TR 53 Div” sheet so that I’m able to paste the next thing.

Please Login or Register  to view this content.

Please see attached

Originally Posted by koklok

Please see attached

Anybody ???

Roy,

Thanks for help but code only works in new workbook or the example
However when I try using it in my actual workbook it doesn't work
I'm little confused with your code because it doesn't refer to any of the sheets that are in example (ALL , or 20&50)
I tried changing your code where it has sheet 1 or sheet 2 but it doesn't work, and I tried many changes but still nothing
Any sugestions what I'm doing wrong?