Unable to capture all the rows

M

Michael1974

New member
Joined
Mar 31, 2015
Messages
49
Reaction score
0
Points
0
Hello,

Please see the attached file. After running the Macro, I am unable to get all the rows from the initial data set. Can someone tell me why and how to fix this?

Thanks
 

Attachments

  • Components.xls
    111 KB · Views: 13
Can someone tell me why
Click to expand...

because the formula putting "Last" into column A is looking for the next line in column C to not be blank.
Beyond row 606 that's not going to happen.
 
You must log in or register to reply here.
Back
Top