Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Please help. Extracting data from one sheet to another
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Please help. Extracting data from one sheet to another
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 A2:D4 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Please help. Extracting data from one sheet to another
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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "leeannemat" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions |