View Single Post
  #4   Report Post  
bala_vb bala_vb is offline
Senior Member
 
Location: Hyderabad
Posts: 237
Thumbs up

Quote:
Originally Posted by Legolas View Post
yes i know but what i need is to edit the formula and to copy data from F
instead of "yes"
thanks

If you want to edit the formulae,

1. go to cell, and edit formulae manually in A2 cell
2. select the entire formulae in the formula bar and use cltr+sht+enter
3. use cltr +D to copy the formulae till A19.

Please refer to attached file that i have modified for you.
__________________
Thanks
Bala