Trying to copy formula from cell above if an entry is made in the row

I'm trying to add a very basic primary key (i.e. 1,2,3,4,5 etc) to a table (either a table using the Table function or simply a blank worksheet) when an entry is made anywhere else in that row (say columns B-P).
If I was using the spreadsheet myself, the formula would simply be =A1+1 and I would copy it down myself (or perhaps pre-populate a few rows at a time). However, I'm trying to add this for other users so the number is populated automatically.
I've seen that Excel's Table function (v2007 onwards) can automatically populate formulae elsewhere in the table, but can't seem to populate column A.

Can anyone help, please?
Thanks

If you have a table and put a formula in the first row, then the formula gets copied to the entire table column.

You can use macro to add row by:

Please Login or Register  to view this content.

Thanks Gerard, that does the job!

Please mark [SOLVED] when problem is solved.
* Add Reputation when you like an answer..

gr
Gerard

Oops I forgot - thanks again!