There are some variable here that need to be defined/taken account of before you'll be able to get reliable results, including:
• do any of the columns on the Data sheet have contents that are unique, so that there can be no mistake as to which columns on the Report sheet are being matched?
• what is the basis, if any, for rows and columns on the Report sheet increasing for each record?
• what process are you using to populate the Report & Data sheets?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|