| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Comparing Data Between Worksheets
I have 1 Workbook with 2 seperate sheets. On Sheet 1 Column A is about 13500
par numbers on Sheet 2 Column A is about 12500 Part numbers and Column B is Item Name. How can I compare Sheet1 Column A to Sheet 2 Column A? How can I compare Sheet 1 Column A to Sheet 2 Column A and then see the ones that are not the same? Can I have excel match Sheet 1 Column A to Sheet 2 Column A and if they match brng the information in Column B over to sheet 1 for the matches? Or am I asking for to much? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining data from several worksheets | New Users to Excel | |||
| have 3 worksheets, 1 is a form, the other 2 data for the form-wan. | Excel Worksheet Functions | |||
| Pivot table retrieving data from several worksheets | Excel Worksheet Functions | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Threaded Mode
