Hi Robert,
apparently the i am looking to export the group of rows along with the '3519' value row ,this code only filters out the rows that contain the "3519" value.. is there a workaround for this?
I don't know what you mean

If you could re-post your workbook showing how the data would look before and after a macro, this should give me a better idea.

Thanks,

Robert