Re: Fwd: $$Excel-Macros$$ Macro for Segrating and file creation

2010-08-08 Thread Vinod N
Thanks a tonn Alpeshah... Macro provided by you solves the Segregation part... Can any other group member help me out for workbook creation? *Conditions/Criteria* > 1. Delete columns C,I, U,X,Y,Z - Solved by Alpeshah > > 2. Delete the rows which has "180" in column A - Solved by Alpeshah > > 3.

Re: Fwd: $$Excel-Macros$$ Macro for Segrating and file creation

2010-08-08 Thread pesh
Hi Vinod, This is not the most efficient way, however I did not have enough time to make it ideal. I have re-used code found on the web in certain cases, source include: http://www.rondebruin.nl/delete.htm for the delete row. Sub code 1 deletes 180 value Sub code 2 deletes "Z0,1,2,WW" Sub code 3