| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing two worksheets
I have seen that there are already other discussions regarding this and
I have gone through quite a few but couldn't quite make sense of it or use the assistance provided there. I have two worksheets. They have multiple columns and I need to compare the two sheets to look for any data thats missing in either sheet or any row that has different info for an employee and then highlight where the difference is arising. Can anyone help about me with this? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comparing two worksheets
You're gonna use the "Window" dropdown.
WindowNew Window. Click the other sheet that you want to view at the same time. Now, WindowArrange. Pick the one you want! I usually use tiled. Hope that helps you. "Spartan" wrote: I have seen that there are already other discussions regarding this and I have gone through quite a few but couldn't quite make sense of it or use the assistance provided there. I have two worksheets. They have multiple columns and I need to compare the two sheets to look for any data thats missing in either sheet or any row that has different info for an employee and then highlight where the difference is arising. Can anyone help about me with this? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing two different Worksheets | Excel Worksheet Functions | |||
| Comparing columns in 2 different worksheets, IF Function | Excel Worksheet Functions | |||
| Comparing two worksheets with two columns each for duplicates | Excel Discussion (Misc queries) | |||
| Comparing worksheets in Excel and highlighting changes | Excel Worksheet Functions | |||
| Comparing two columns in two different worksheets | Excel Worksheet Functions | |||
Linear Mode
