Want a formula or a macro

 Hello Vishesh,

 

As per your instructions I have placed your code in to my sheet 1 , but when I run the macro I get compile error, I have attached the same file in which I pasted your code please try your self by running the macro and suggest what to do next...

 

Thanks

AttachmentSize
ex.xls14.5 KB
Vishesh's picture

Solved

for solution chk this

http://excelexperts.com/node/1114

I have provided a button on the sheet; click on it and see the results