ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Using a comparison and taking data from one sheet and putting it i (https://www.excelbanter.com/excel-worksheet-functions/118240-using-comparison-taking-data-one-sheet-putting-i.html)

Tonya

Using a comparison and taking data from one sheet and putting it i
 
I have two sheets and both with ID's and Names. I only need 50 of the ID's
and Names but they are specific that I need out of the other sheet that has
all 750 ID's with names. Instead of doing a find and copy and paste into the
new sheet is there anyway to compare the two and put the values that I need
to the left of the column B in Sheet 1 and place the ID's in Column A of
sheet 1 out of Sheet 2 (Where all the data is found but I only need the 50
and not the 750 that are unique)




All times are GMT +1. The time now is 02:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com