Is there a way to compare pictures in two different workbooks.

madgulakrishna

New Member
Joined
Sep 16, 2014
Messages
2
I have a workbook as a baseline which contains pictures in it. Next time I generate a new workbook with the same data which I will be saving it as generated one.

I need to compare whether the two workbooks matches or not.

If it has only the textual data then its fine.

In this scenario, I have pictures in it.
The pictures are embedded in the Cell, the height and width remain the same in both the workbooks.[This includes order also]

If anyone can point to the right direction that would be great.

Thanks in advance.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

charlie727

New Member
Joined
Aug 3, 2014
Messages
12
hello Madgulakrishna,

The way I would recommend is to open both workbooks. In the first workbook in the view tab there is button near the top right call "View side by side" which allows you to open two workbooks in one excel window.

Just make sure after you've hit the button to restore down the inner window in the top right (Very important to restore down the INNER window and not the outer window) otherwise you won't be able to see it and just be restoring down the whole excel workbook.

Once you've done that you can tailor the size of the two windows and compare.

To help with this as well is a small button just below the "View side by side" which allows you to scroll both windows simultaneously. This helps compare

Hope this helped

Kind Regards

Charles
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,983
Messages
5,834,707
Members
430,311
Latest member
JAC0617

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top