A worksheet is not a "doc".

It is nothing more than one worksheet within an Excel workbook which could
contain multiple worksheets.

Do you want a new workbook created for each row of data in Workbook A Summary
worksheet?

Or just a new worksheet within Workbook A?

Take a look at Ron de Bruin's site for various copy/paste/merge scenarios.

If you see nothing to your liking, post back more details and drop the "doc"
designation.


Gord Dibben MS Excel MVP

On Sun, 4 May 2008 14:31:00 -0700, ema wrote:

I have a worksheet which holds summery of information. The column heading are
for exsample : arrival date, name, tour type etc... Each row, hold details
of individual entries.

From this doc I want to link / copy these details into another doc. Each
row / entry of details, should be automatically filled into same named fields
in the new doc. Each entry / row of the summery doc, will have a complete new
doc.
How do I do this.