![]() Compare and Match Data from 2 Worksheets by Viewing Side-by-Side in Similar Workbook This method is helpful when you have to compare a small amount of data visually and find matches side-by-side from two workbooks.Īs we’ve enabled Synchronous Scrolling, so if we scroll down in a workbook another workbook will follow the action accordingly.Ģ. Like in the screenshot below, you’ll be displayed two workbooks side-by-side and you’ll be able to compare data and find matches easily here. ![]() ➤ Choose the Vertical radio button from the options. ➤ Select Synchronous Scrolling under the View Side by Side option. ➤ Under the View tab, select the View Side by Side command from the Window drop-down. Now we’ll display these workbooks side-by-side and compare data visually for matches. Both workbooks have some data starting from the same row in Column B. Let’s assume we have two different workbooks named ‘Book 1’ and ‘Book 2’. Compare and Match Data from 2 Worksheets by Viewing Side-by-Side in Different Workbooks ![]() 6 Suitable Methods to Match Data from 2 Worksheets in Excel 1.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |