Try this:

Say you want the data from workbook A into workbook B--
Open B. Turn on the vba recorder
Open A. Select the cell where your desired text is. In the formula bar
select the text you want, click Ctrl+C to copy.
Activate B. Select the cell where you want the comment.
InsertcommentCtrl+V to paste the text.
Stop the recorder and study the code. Adjust as needed.


"Wayne" wrote:

I would like to get the text in a cell in one file and
paste that text as comments to a second cell in another
file. Have tried a number of things but no luck!!

Wayne