Hello,



I have 2 reports that contain similar columns with identical titles. One report is more complete than the other one. I would like to complete my newest document with the missing data from the more complete document.
In column C (for example) of the complete document, I would like to that that info and copy and paste it in my column C of my newest document.

Any help is appreciated!

Thanks,

L.

If it's simply a matter of one sheet having more data that the other, why not simply copy & paste from the 'larger' sheet?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for replying!
Because the sheets are not quite identical
for example:
In cell A5, I will have the project number 156565-001 in the more populated document
In the new document, in cell A5, I have 165656-001. But the project number 156565-001 is still present in the new document, but is in cell A34.
So.
I need a way to match what is in cell A5 and A34.
Ideas?

Thanks!

So, given that the order is different, what do you want to do about the difference in ordering?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]