selecting a table with variable rows and columns

I’m trying to select all data in a table to move to another sheet, but the table will change every day so I need the selection to change with the table. I’ve used end(xlUp) often to find the bottom row, but I’m not sure how to combine that with a variable column number.

I keep getting an “Object required” error message.

Please Login or Register  to view this content.

Thanks for any help.