| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Collate data from one spreadsheet into another spreadsheet
I have two spreadsheets. Spreadsheet A has a list of 500 clients. Spreadsheet
B has a list of over 5000 members. I need to know if any of the 500 clients in Spreadsheet A appear in Spreadsheet B, then collate this data in a new spreadsheet. We can assume the members' first name and surname are in separate columns. There is also a column with each member's account number. Is there a formula that can locate and extract the data I need? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking 2 spreadsheet using data from 1st spreadsheet | Excel Discussion (Misc queries) | |||
| Variable data from one spreadsheet sent to new spreadsheet | New Users to Excel | |||
| Can I pull data from a spreadsheet to another spreadsheet | Excel Discussion (Misc queries) | |||
| How do I copy spreadsheet data as shown to another spreadsheet? | Excel Discussion (Misc queries) | |||
| summarize data from one spreadsheet to other spreadsheet | Excel Worksheet Functions | |||
Threaded Mode
