| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help finding a fast way to cross reference data between sheets???
I have two spreadsheets. The first one contains about 300 companies I am
finding data for and the second one contains the 300 companies plus a thousand more companies. I need to locate the 300 companies on the second excel and copy the data into the cells on the first. How do I do this with out doing it one by one? I have to do this a couple times : ( Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help finding a fast way to cross reference data between sheets???
http://www.cpearson.com/excel/Duplicates.aspx
-- Regards, Peo Sjoblom "Scott" wrote in message ... I have two spreadsheets. The first one contains about 300 companies I am finding data for and the second one contains the 300 companies plus a thousand more companies. I need to locate the 300 companies on the second excel and copy the data into the cells on the first. How do I do this with out doing it one by one? I have to do this a couple times : ( Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cross Reference Vertical and Horizontal for Data | Excel Worksheet Functions | |||
| Cross Reference Table Data Searching | Excel Worksheet Functions | |||
| Finding Data from Multiple sheets | New Users to Excel | |||
| Cross Reference between sheets | Excel Worksheet Functions | |||
| Finding the value for the point two lines cross | Charts and Charting in Excel | |||
Linear Mode
