fill data automatically into another worksheet

[ema]

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.

 

[robzrob]

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.

Go to the first cell in the new worksheet where you want the first
piece of data to appear, click = then go back to the summary doc and
click on the cell you want to appear in the new document. In the new
document, copy across.

 

[Gord Dibben]

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