Formatting excel sheet

Hi

i will try to explain best i can and i have attached a sheet

the column highlighted in yellow follows a sequential number system e.g, 1, 2, 3, 4 etc etc

These sheets can get very long and i can have quite a few. it takes me ages to number these up and when i insert a new row i have to re-number all the ones below manually.

is there a formula that will look to see if column G is filled out and if so put the next number is from the one below.

the main problem is that when there is spaces and therefore these cells would be blank?

many thanks for your help - this will save so much time if i could solve this

thanks

scottapple,

Please see if this is what you need.
In Cell A11 copy this equation and paste down as far as you needed it.

PHP Code: 

=IF(G11="","",COUNT($G$11:G11)) 


thanks - perfect!

Hi Scott
An alternative is to run a macro. Cut and paste this macro into a module in your workbook and run it each time you insert news rows:

Sub ReNumber()
Dim Rows As Integer
Dim rw, ItemNo
ItemNo = 1
Rows = ActiveSheet.UsedRange.Rows.Count - 1
'MsgBox (Rows)
For Count = 8 To Rows
Range("A" & Count).Select
rw = Range("G" & Count).Value
If rw = "" Then
GoTo NextRow
End If
Range("A" & Count) = "5.N." & ItemNo
ItemNo = ItemNo + 1
NextRow:
Next Count
End Sub

Good luck.
Tony