Need help Visual Basic Copying Rows until Empty Cell

[nkf531]

So I need help with this problem, I attached a file for an example. That I need VB formula to make my life easier than going through thousands of sheets. What I was hoping for help with is a formula that will go from Row 38 downards until empty Cell D is found (i think this would be easier to do than saying if A=Total Time report distribution) If doing until A = total time report distribution that would be even great as well. Then I would want it to copy and paste that into a new sheet or workbook.

All in all these are fake numbers i put in but What I really want is just the rows being copied until it meets the set criteria on to a new page or sheet which i can't figure out. Any other organizing i figure i can do a record macro to make it easier. Thanks!!!

[royUK]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.