Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to separate data....
Hi, I have worksheet with values which repeats in colums A How to copy data with repeating values to x worksheets automatically. for example All data from Sheet 1 which contains A values in column A(ID) copy to sheet A All data from Sheet 1 which contains B values in column A(ID) copy to sheet B All data from Sheet 1 which contains C values in column A(ID) copy to sheet C Pls see file in attachment. +-------------------------------------------------------------------+ |Filename: exp.jpg | |Download: http://www.excelforum.com/attachment.php?postid=4023 | +-------------------------------------------------------------------+ -- Oleg ------------------------------------------------------------------------ Oleg's Profile: http://www.excelforum.com/member.php...fo&userid=4004 View this thread: http://www.excelforum.com/showthread...hreadid=483853 |
#2
|
|||
|
|||
How to separate data....
Hi, I would use a helper column and formulas. Try this, select column A and insert a new column, column A will now become column B. In the new column type this formula: =IF(B1"",B1&COUNTIF($B$1:B1,B1),"")....copy down and Hide column now select your A sheet, in column A type: =IF(COUNTIF(Sheet1!$A$1:$A$25,"A"&ROW(1:1))=1,"A", "").....copy down in column B type: =IF(A1"",VLOOKUP(A1&ROW(1:1),Sheet1!$A$1:$C$25,3, 0),"")....copy down repeat for your B and C sheet replacing the "A" with "B" and "C". HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=483853 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Compare data on 2 separate worksheets. | Excel Worksheet Functions | |||
How do I compare 2 sets of data and highlight differences? | Excel Worksheet Functions | |||
filter data from 10+workbooks and display in separate workbook? | Excel Discussion (Misc queries) | |||
Removing blank rows in a worksheet | Excel Worksheet Functions |