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