Hi All,
I have a excel workbook containing 20,000 rows of data. I will have to develop a macro to copy a certain range of data from that excel workbook & paste the same in another excel workbook, rename the workbook & save. Suppose one column contains certain rows with values as 1, next set of rows as column value=2, another set of rows as values =3. I will have to take all the rows corresponding to value 1 and paste in the second excel workbook, rename, save & close. This process repeats for column values=2 & 3 as well.Please help in writing the Macro Code.

The source Excel resides in the location:E:\Ani\SIMS
The destination excel resides in the location :C:\AM\SIT

Please help me in writing the Macro for the same as this is URGENT for me. Looking forward to your kind assistance with the Macro Code for the same.

Thanks
Ani