DDE output to existing Excel worksheet

DDE output to existing Excel worksheet

We have master blank worksheets for all of our parts with balloon numbers and all related dimensional info, once we enter the measured dimension, it will show "pass" or "fail". Up to now, we print the report from CMM Manager and manually type in the results to the worksheet. Is there an easy way to setup the output to fill in these measured values (only "actual" results) into the worksheet? I see you can paste cells from a worksheet but it will not let me do it with the worksheet open to select and paste the cell.. Any help is greatly appreciated.