Hi all, I have a report, actually multiple reports, where there are a great number of fields and one comment field at the end. This comment field is filled in manually when reviewing the each month. Right now, the report does not bring forward the comments from the previous month, and that's been a source of time wasted because certain records end up being reviewed repeatedly before realizing, "Oh, we reviewed that last month and the comment is there but is not in the new report". Is there a way I can have that one comment field brought in from the previous month easily? These reports are very wide, and each report has different variable names. I essentially want to merge the last months file with the current file on all fields EXCEPT the comment field, and I want to make it macro enabled to work with all the reports. Are there are good ideas on how to accomplish this? -Paul
... View more