Data entry/ forms

Here goes….

I am trying to develop a way in which I can standardise data entry.

I am developing a system for a project developer, who needs a way to easily enter project details and a way in which to retrieve useful information such as the “total number of invoices”, “max value of invoices” etc.

First method

I have tried designing a template but that hasn’t worked very well. I recorded a macro, which would select the template (filled out), and copy and paste it in to another sheet where projects would be stored. The first project when saved is fine; however the second overwrites the first project entered.

Second method

I tried developing a form but I am not that good with VB editing. I need some major help.

Thanks.

iv looked at your example.

ive created a form in VB with what i want on it.

how do i link a macro to that user form?
how to i get the info from that form under the headings in the sheet. your form does it by clciking "add"

thank you