| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting data from one sheet into another
Consider moving the 600 entry table from the second workbook to a new tab in
the first workbook. This will avoid having workbook-to-workbook links. See =VLOOKUP() in Excel help. This will enable you to retrieve values for each ZIP code in the large table. -- Gary''s Student - gsnu200768 "T" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting data from one sheet into another
Sounds easy enough, thank, I'll try it now.
"Gary''s Student" wrote: Consider moving the 600 entry table from the second workbook to a new tab in the first workbook. This will avoid having workbook-to-workbook links. See =VLOOKUP() in Excel help. This will enable you to retrieve values for each ZIP code in the large table. -- Gary''s Student - gsnu200768 "T" wrote: 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. |
| Reply |
| 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 | |||
Hybrid Mode
