| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting data from one sheet into another
In Workbook 1 I have a mailing list with typical fields, name, address, city,
st, zip, etc. This workbook has over 50,000 records and I need to pare down the list based on zip codes. In Workbook 2 I have 600 zip codes in column A and a unique value for each zip code in col B, ranked 1 through 600. Can I somehow add these zip code 'values' from workbook 2 into a new column Workbook 1 if the zip code in Workbook 1 matches a zip code in Workbook 2? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting data to another sheet using multiple criteria | Excel Discussion (Misc queries) | |||
| Please help. Extracting data from one sheet to another | New Users to Excel | |||
| Extracting information from records to another sheet automatically | Excel Worksheet Functions | |||
| Extracting information from records to another sheet automatically | Excel Worksheet Functions | |||
| help extracting data from an excel sheet | Excel Worksheet Functions | |||
Threaded Mode
