| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting Data from one spreadsheet into another
I have 2 spreadsheets. 1 contains a list of customers with full post code ie
ABC Ltd/123 High Street/ London/ N15 ABC The post code in the final column could be either 6 digits (as above with space in middle) or 5 digits ie B1 EDR, 7 digits ie WC1A BNM I have another spreadsheet detailing a sales consultant with the postcodes they cover ie Sally Smith/ N15 Audrey Green/B12 Geoff Smith/B15 I need to get the Sales Consultants name into the Customer spreadsheet - there are 8,500 lines so I need something automated rather than a manual task. Can anyone help? Many thanks - Elaine -- Elaine |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Two Questions: R1C1 and stop text number converting to data | Excel Discussion (Misc queries) | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Baffling! Spreadsheet Data Form Size | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
