Help on VBA and Excel
Hallo,
I am not a VBA/Excel programmer, so I would like your help.
The below is what I have. Three columns of Excel in Sheet1.
A B C
---------------------------------------------------
John $30 $0
Smith $20 $10
What I want to do is the following in Sheet2.
A B
--------------------------------
John $30
Smith $20
Smith $10
How would I do it? I'd like your help.
Thanks in advance.
Kumar
|