Resize table to my used range

I have a table where I log my requisitions, so about 12 columns of data per row, many with formulas. I have a macro that automatically inserts the next row, copying the pertinent formulas, and that works well for me when I'm entering a ton of different requests. My issue is that once a month I get about 20 requests at the same time. Except for the date the information on all of these requests exactly matches the information I entered last month, so my usual process is to filter to those requests from last month, copy them, and paste them under my table, change the date information (and the one or two other things that might have changed). I then resize my table to include those rows.

That last step is what I need help with. I'd like to create a quick macro that resizes my table to the size of my usedrange. I tried working with my recorded code, but can't figure how to get the usedrange property worked in. Any help would be appreciated.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Let me know if you have any questions.

Okay, here's my finished code:

Please Login or Register  to view this content.

UPDATE: Changed it to convert my used range to a table if a table doesn't already exist.