Compare worksheet data

C

Candida

I have two worksheets that are in separate workbooks that I need to compare.
The information is structured the same in both sheets. However, there was an
update to the bill of material which may have added rows of information
throughout the sheet, or may have added additional information within the
columns of other components. However, both worksheets have the exact same
headings and formatting. Is there any way I can compare the two and update
the older worksheet with updates from the new? Can someone help please?
Thank you Candida
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare 2 worksheets 1
Compare difference between 2 worksheets 2003 1
Worksheet Compare 1
IFERROR TO COMPARE WKSHEET 2
compare all data in one worksheet to another 1
Compare and merge worksheets 2
Compare worksheets 4
compare excel worksheet and output difference to new worksheet 1

Top