Hi,
this is really very simple to do.
I have an excel data entry form (Data Entry [login to view URL]) that is currently printed out by a salesman, manually written on with a pen and then manually entered onto a database.
In order to import the file automatically it will need to be in a column and row format (see Data [login to view URL])
What I need is an excel template that has two worksheets.
the first worksheet is a data entry form, created using visual basic. (i have even attached a doc with a tutorial how to do this- see "Excel User Forms - Create a [login to view URL]) and the second worksheet (behind it) is the actual data in columns and rows.
So every time the sales person adds a new contact to the data form they will click an "Enter Contact" button and the details will be put in the next row of the data sheet and the data entry form is cleared for the next one
I could do this myself by following the tutorial but I really don't have time to spend doing it I have a deadline of Fri 8am (UK time)
## Deliverables
1. Delivered by 8am Friday (uk time)
2. Fully working
3. Completed in the same format as the tutorial sheet so that I can then later on go in and edit it (add new fields etc)
4. If you don't want to use the exact same code as the tutorial please supply instructions for editing or adding a new field
## Platform
Win 2000
Win XP
Excel (any current version)