I am trying to adjust the below VBA so that after it copies the inputted data into a new sheet it also formats it into a table. Currently, the code sets the table to 30 rows. However, because the data I will input changes from project to project, I would like to set the table range to adjust to the amount of rows in the data after the code has run and each of the sheets have been created. Is there a good way that I can do this? I've had trouble changing the range and usually when I alter it I can't get the table to be created at all. Thank you for your time!Snip of VBA Code.jpg