Hi Alex

If you have Excel 2003, then use DataList to create your table.
Then as you add new rows, the formulae will automatically get added.

--
Regards

Roger Govier


"Alex" wrote in message
...
Hi

I use the following to test the last character in a cell.
=IF(RIGHT(E4,1)="A","Yes","No").

When I add more rows, I am always forgetting to copy the formula down.
is there anyway that i can set up the worksheet so that I dont have to
remember

Thanks
A