Creating a separate excel using Macro

Posted by shayam on Stack Overflow See other posts from Stack Overflow or by shayam
Published on 2010-11-06T06:45:14Z Indexed on 2010/12/31 1:54 UTC
Read the original article Hit count: 522

Filed under:
|
|

Hi, I am having a excel with one column that has got information regarding tender. Each cell will have a value like

Column: Nokia([Mode1.Number],OLD)

Column: Motorola([Mode1.Number],OLD)

Column: Motorola([Mode2.Number],NEW)

Column: Motorola([Mode3.Number],OLD)

Column: Samsung([Mode2.Number],NEW)

I need to create 2 excel out of this. One should 've all the information of the OLD and the second excel should've all the information of NEW.

So my output excel should contain

First Excel

Nokia([Model1.Number])

Motorola([Mode1.Number])

Motorola([Mode3.Number])

Second Excel

Motorola([Mode2.Number])

Samsung([Mode2.Number])

Kindly help me.. Thanks in advance..

© Stack Overflow or respective owner

Related posts about excel

Related posts about vba