NoSparks, it works! One of the lines about halfway through the spreadsheet didn't have a space between it and the row above it and it's what was making the macro fail, but now it works just like I needed.

Thanks guys!