we are almost there sir. the thing is my sheet has live stock rates. so if you have an external link you will see that , it doesn't automatically speak the names when it comes to 1.5 but only if i manually write 1.5 in column B.