Threads merged.
It would have been helpful if you'd said up-front what the full requirements are. In addition to needing the additional column, you're evidently pasting multiple tables into the same Excel workbook, so pasting into a new, empty, workbook isn't the end of the matter. Presumably you also need to add the data to below the existing data. At which point it becomes better to automate this from Excel so multiple documents can be processed instead of doing things piecemeal.
Accordingly, please provide the full details of what you're trying to achieve.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|