I will try. I am not sure where to enter that code. I did attach the data file. If I have trouble I let you know.
Another helpful task would be to delete any row with a 0 in column E "qty"
I normal use filter to delete all the rows with 0 before I run you macro. If the was included that would be great.
Thanks for the quick reply.