Pull data from another sheet based on certain criteria

Posted to microsoft.public.excel.misc

steve_sr2

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combining data from cells from several excel sheets to a new sheet	Rik	Excel Discussion (Misc queries)	4	February 22nd 06 09:16 AM
Importing Data	Jillian	Excel Worksheet Functions	9	December 23rd 05 12:45 PM
How do I pull certain data from several worksheets in one sheet?	Deler	Excel Worksheet Functions	0	July 28th 05 06:45 PM
pull data from sheet two, then fill in the data to sheet one (part	Jim	Excel Worksheet Functions	3	December 11th 04 04:51 AM
Function to automatically insert a new sheet as a result of data entry?	Mark Mulik	Excel Worksheet Functions	2	November 28th 04 02:21 AM

All times are GMT +1. The time now is 01:14 PM.

Menu

About Us