Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find matching data in two workbooks
I have data in multiple sheets of one workbook I am trying to match to data
in multiple sheets in another workbook. The data is contained in various columns a through z and various rows. Ideally, the data contained in workbook A would be searched for in workbook B and if found, turn the matching data in workbook B bold red font. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find matching data in two workbooks
On May 5, 10:09 am, franklinbukoski
wrote: I have data in multiple sheets of one workbook I am trying to match to data in multiple sheets in another workbook. The data is contained in various columns a through z and various rows. Ideally, the data contained in workbook A would be searched for in workbook B and if found, turn the matching data in workbook B bold red font. You want to use conditional formatting, but you can't across sheets/ workbooks. I don't know if there is a slick way, but there is a brute force way.... Go off to the left of your data in workbook B (assuming your data is A1:Z100, goto AA1:AZ100) and do a comparison between A1:Z100 in each workbook. Formula is something like: =EXACT([workbook A]Sheet1!A1,A1), copy to each cell in AA1:AZ100. It will return TRUE or FALSE for each cell. Then select the range A1:Z100, do conditional format of bold red font with the formula: =AA1=TRUE. Make sure to use a relative reference with no dollar signs so each cell will be done properly. Should turn all the matches in A1:Z100 to bold red. You can hide the columns AA:AZ so you don't have to see the calculation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching data between Worksheets in different Workbooks | Excel Discussion (Misc queries) | |||
Matching data on two workbooks | Excel Discussion (Misc queries) | |||
Formula to Find Matching Data | Excel Worksheet Functions | |||
Find Matching Data Two Columns | Excel Worksheet Functions | |||
Matching Data in Two Workbooks | Excel Worksheet Functions |