Thanks for both of your responses! I have tested them and they both work great!

I have one quick question, is there an easy way to sort the macro output in the Export tab after it has finished generating the lines? Smuzoen, I noticed your macro automatically sorts the output entries by the Name order, which is great. If the need came up for example, could I sort it first by Name and then by Store and then by Date?

Thank you both again!