Hey folks, I'm really still trying to formulate this, but the idea simply is to have sheet one with records. Sheet two would have an embedded Word document, or pdf if that would be easier. Areas in sheet two would be filled in with values based on what record was selected on sheet one. I know i did something possibly identical to this about 15 years ago, but i can't recall how nor can i find one of the workbooks, though i think i used an embedded pdf and somehow linked fields on the pdf to fields, but i can't recall if the fields were first created in the pdf or if i somehow mapped the fields once the document was displayed in Excel. Heck, i might of even used it as a background and linked text boxes to the cells for all i can recall...

If this is hairy I will need to "just" recreate the Word document in Excel for sheet two, but it will be a bit of a pain, and I'd rather learn something new like this than take the old sledgehammer approach if possible. If I can link the areas in the embedded Word document, whether they be bookmarks or fields or something else, to a series of specific cells, then when a record is selected it copies the cell values to that specific cell series, would seem to be the easiest first step, and I can easy enough embed the Word or pdf document, but what to use as the "placeholders" in the target document I have little if any clue, and then how to link those to the cells would be the next trick.

I likely am going about this convoluted for it's my first pass and i could use some sleep, so ALL options o direction are open!

Thoughts?