Excel '10 Automatically create rows inc formula, data valid, cond format etc

[marsham]

I have created an expense type claim form and given my limited skills think it’s actually looking pretty good.
The one thing I would like to do to finish it off would be to:

Automatically create rows as required, which would keep all the formula, conditional formatting, data validation etc, whilst leaving the total $ row at the bottom, and authorisation field in the footer.

My skills are not great but they certainly are advanced in comparison to the users of this document, so I will be protecting the cells etc in order that they cannot amend it.

I believe a Macro may be the way to do this, but I really know NOTHING about them, so this would really need to be a dummies lesson.

I have attached (tried to) an example – the actual file would have significantly more info in the data validation lists.

I appreciate your taking the time to read this, and look forward to your assistance.

The rows are as follows:
A User enters info. This however is then MIN/MAX to create range in J3 & J4
B Data Validation (can be typed or selected)
C User enters info. No protection, cell extends if required
D User enters info. No protection, cell extends if required
E Locked cell – formula derived from value typed in row G
F Locked cell – formula derived from value typed in row G
G User enters info. No protection, linked to formula in row E & F
H Data Validation (can be typed or selected)
I Locked cell – formula derived from row H
J Data Validation (can be typed or selected)

[TMS]

I've not looked at your spreadsheet yet, but I suggest you have a look at Tables in Excel 2010.

It sounds like converting your data to a Table would give you exactly what you want without VBA.

Regards, TMS

[marsham]

TMS

Thank you for your response.
I'm not at all familiar with tables so am a whole lot confused as to what you mean.
I did try to do some investigation via Google, but am more confused than when I started.

Could you give me a bit of an explanation?

I thought a macro would be the right track as when I tried to find the answer to my Q, many of the forums talked abot them, just none of them were quite right for what I wanted & I don't know enough about them to adjust to suit.

Thanks