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

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