Quote:
Is there a way to assign the macro to move information into a table as opposed to the worksheet?
|
Yes... add it as a listrow within the table or as an addition to the bottom of the table.
See the '
Inserting rows and columns' part on
this site.
The VBA Guide To ListObject Excel Tables is another site dealing with tables.