vaibhav2312, I'm having trouble understanding what you want to do. I can see your attachment just fine, but have no way to decipher what the phrase below means: 
copy above cell value down to column up to range of column "A"
Please advise.