software

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

use the vlookup function copied across changing the col no as required
--
paul
remove nospam for email addy!
quot;steve_sr2quot; wrote:

gt; I have a spreadsheet with multiple rows of information. How can I pull all
gt; rows of info based on certain criteria, into another spreadsheet.
gt;
gt; Sheet1
gt; Name1, Data, Data, Data
gt; Name2, Data, Data, Data
gt; Name1, Data, Data, Data
gt; Sheet 2
gt; Name1, Data, Data, Data
gt; Data, Data, Data