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.
Bookmarks