Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating data into new sheet
Hi guys,
I have the following data on worksheet "Sheet1" Code Value A 1000 B 200 A 100 C 150 B 300 B 200 C 400 I have worksheet "Sheet2" that I want user to input what CODE they want to IMPORT... Let say A then on "Sheet2" i would get: Code Value A 1000 A 100 It is a combination of sorting, copying and moving the wanted data to the targeted sheet. Is there an excel feature/solution that does this? or a VB code is needed? Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating data into new sheet
One way ..
Your source table as posted in Sheet1, data from row2 down In Sheet2, Let's say the input for the code will be made in A2, eg: A In C2: =IF(A$2="","",IF(A$2=Sheet1!A2,ROW(),"")) In D2: =IF(ROWS($1:1)COUNT($C:$C),"",INDEX(Sheet1!A:A,SM ALL($C:$C,ROWS($1:1)))) Copy D2 to E2. Select C2:E2, copy down all the way to cover the max expected extent of data in Sheet1's col A. Minimize col C. Cols D & E returns the required results dependent on the input code in A2, all neatly packed at the top. Joy? hit the YES below -- Max Singapore --- "apache007" wrote: I have the following data on worksheet "Sheet1" Code Value A 1000 B 200 A 100 C 150 B 300 B 200 C 400 I have worksheet "Sheet2" that I want user to input what CODE they want to IMPORT... Let say A then on "Sheet2" i would get: Code Value A 1000 A 100 It is a combination of sorting, copying and moving the wanted data to the targeted sheet. Is there an excel feature/solution that does this? or a VB code is needed? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating data in a column | Excel Discussion (Misc queries) | |||
Separating data | Excel Worksheet Functions | |||
Separating data from cells | Excel Worksheet Functions | |||
Separating data in a cell | Excel Discussion (Misc queries) | |||
separating data | Excel Discussion (Misc queries) |