Is there ever more than one item1 in col A and are there ever more than 2
other columns? Easier if yes.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike G - DC" wrote in message
...
Folks - I'm looking for some code to copy data from worksheet A into
Worksheet B like the following example. This code will fire as part of
another macro. Any help is much appreciated.
Thanks, Mike


Worksheet A
A B C
1 item1 10 20
2 item2 12 19
3 item3 13 89


Worksheet B
A B
1 item1 10
2 item1 20
3 item2 12
4 item2 19
5 item3 13
6 item3 89