I have opened another sheet called sheet2 where I copied the data form column A and B from sheet called "existing".
I made the sheset2 as active sheet.(you need not do it. the macro does it)
now run the macro "test"
after running the macro I copied the columns A and B from sheet "required" and pasted it on C1 in sheet2 so that you can compare the result of the macro and required
your file now called "book 2 ANANTH.xls" is returned.
If you want to recheck the macro
do this "undo" macro given below
after re running the macro you again copy columns A and B from sheet "required" and paste it to D1 of sheet2 for verifying .
As you are messing up with data keep the sheet "existing" as it is and do the macro on sheet 2 so that the original data can be retrieved if there is a problem.,
your feedback please
Bookmarks