Help with Excel VB Script

[Petes]

Hi there,

I must say that I am completely VB illiterate and hence need some help with the following.

I am trying to create a bill of costs spreadsheet in Excel which I have successfully completed. I want to add the option of increasing a line at the bottom (between the final line and the Total Sum).

I was able to create a macro to add the line but had difficulty with making Excel always add the line to the bottom of the list as the list always gets bigger and hence the last line is always updated.

Does this make sense? Can anyone help with writing some simple script?

Thanks,
Petes

PS. Attached is a sample file.