Thank you! Unfortunately I cannot add the file because it contains confidential information. I'm not sure if I can possibly name my table as a specific range and then put in a code that will go to the first empty row within that specific range. I'm sure there is a way to do this, just need a little help!!!