Thanks for the kind words. The formula used was Visual Basic code and it's a whole other bear it can use the regular worksheet functions but basically makes it possible to do anything with Excel ( I havent found something Excel cant do it yet)

Thanks please feel free to mark as solved.

i am trying make this work in my original worksheet but i am so noob that i could not do that(shame on me) i even do not know how to make a button to run this micro or visual basic code

if you please guide me how do i do that i will be highly thankful to you

also tell me why it is asking to save (when going to close the file) even when no changes has been made?

Thanks again