MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to sum a comment


Posted by Patrick on February 06, 2002 3:40 AM

I have this formula
SheetA1=('Mgr Schedule'!E12)
in Mgr Schedule'!E12 there also is a comment....
is there anyway to have that exact comment show on
SheetA1.....w/o putting it again
hope this is clear....it's a very early morning here:)
thanks


Posted by Juan Pablo G. on February 06, 2002 7:48 AM

Copy 'Mrg Schedule'!E12, go to Sheet1!A1 and Paste Special, and select comment.

That should do it.

Juan Pablo G.