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