I successfully took a Crystal Report query and used it to retrieve data into a Excel workbook.  In addition to this data, it is desired that another column is created in the workbook for comments.  

My problem is when the data is retrieved, the comments column created after the retrieval is blanked out and doesn't follow the data retrieved.

Is this possible?  We'd like to display a query of order, make comments, and update on a regular interval.

Thanks in advance.

Hi Johnny,

Your refreshed date may or may not align to the related comments.

Does your dataset have a unique ID/Key ?

If so I suggest that the comments be stored in a separate sheet along with the Key in a separate column and you use a Vlookup to rematch comments to your Data...