| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull data from another sheet based on certain criteria
I have a spreadsheet with multiple rows of information. How can I pull all
rows of info based on certain criteria, into another spreadsheet. Sheet1 Name1, Data, Data, Data Name2, Data, Data, Data Name1, Data, Data, Data Sheet 2 Name1, Data, Data, Data Data, Data, Data |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pull data from another sheet based on certain criteria
use the vlookup function copied across changing the col no as required
-- paul remove nospam for email addy! "steve_sr2" wrote: I have a spreadsheet with multiple rows of information. How can I pull all rows of info based on certain criteria, into another spreadsheet. Sheet1 Name1, Data, Data, Data Name2, Data, Data, Data Name1, Data, Data, Data Sheet 2 Name1, Data, Data, Data Data, Data, Data |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining data from cells from several excel sheets to a new sheet | Excel Discussion (Misc queries) | |||
| Importing Data | Excel Worksheet Functions | |||
| How do I pull certain data from several worksheets in one sheet? | Excel Worksheet Functions | |||
| pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Linear Mode
