Please help. Extracting data from one sheet to another

[Guest]

Can anyone please help me. I have a front worksheet that is our main data
input sheet and several information sheets that will contain the matching
criteria from the main data entry sheet.

EG. Spa Company that maintains all information on their quotations.
Description of Spa( 2,4,6 & 8 Person Spa's), Name of Client, Address of
Client, Successful Yes/No.

When a quote is entered for a 6 person spa then I would like all the
information in that line to extract to the 6 Person Spa Quote sheet also
indicating whether it is successful or not.

 

[flummi]

Provided I've got your requests right, here's a way:

descr name addr succ
2 Fred NY yes
4 Michael Chic no
8 Mary Bost yes

Search
4
results
descr name addr succ
4 Michael Chic no

Your data in A24
Your search criterion in A7

Type in A9:
=OFFSET($A$2;MATCH($A$7;$A$2:$A$4;0)-1;COLUMN(A9)-COLUMN($A9))
copy across to D9

That gives the above results.

Hope this is it?

Hans

 

[Max]

Perhaps try also this response to a similar query
http://tinyurl.com/exxre
(one way which uses non-array formulas)

The sample construct given in the thread is (still) available at:
http://www.savefile.com/files.php?fid=9963202
Auto-Filter_Data_To_Resp_Sheet_Non_Array_Approach.xls

The key column "Cat" in the sample would be equivalent to your key col: "Spa
Description" where you would presumably have listed down in the column
standard text such as:

2 Person
4 Person
6 Person
etc

And you would have your individual sheets named
to match exactly the above standard text