Excel Form and Sheet

Budget $10 - $15 USD
Bids 1
Average Bid $12

This project requires basic VBA and macro knowledge to put together an excel worksheet filled with data entered through a custom made data input form.

## Deliverables

When the excel file is run; the user will see a spreadsheet with rows of info in


it. (refer to the picture)
At the very top, there will be a button: "Add New"
When pressed this button will pop a customized form for the user to enter
data.
When all fields in the form are filled and save button is clicked the form
window will close and the info will be recorded on the excel sheet.
The fields in the form: (also refer to the picture)

1. Date - should be formatted as DD/MM/YY . The button next to the field
should post today's date.
2. Customer Title - basic text.
3. City - basic text
4. Contact - basic text
5. Amount - number. Thousands should be divided by "," to "2" decimal
points.
6. Currency - The dropdown list should include "EUR", "USD", "GBP", "JPY"
7. Total - number. Thousands should be divided by "," to "2" decimal
points.
8. Type - number. the dropdown next to it should list "%p.q" and "%p.a" and
should add this selection right next to the info from type field. Both info
should be recorded in to same cell.
9. Details - text. Options: "wrap text" and "shrink to fit" should be
enabled.
10. Status - drop down list should include "New", "Complete", "Error"
11. Last Update - should be formatted as DD/MM/YY . The button next to the
field should post today's date.

When all this info is entered/selected and "save" is clicked. The window
will close and the spreadsheet will be displayed with all the info entered
into the appropriate cells.

"Auto Filter" should be on for the whole of the spreadsheet.

Font type, size and coloring is upto you as long as everything is clearly
readable.

All data in the spreadsheet should also be editable manually in case any
changes should be made.

(See attached file: [url removed, login to view])(See attached file: [url removed, login to view])

Post a Project Like This

This project was awarded to

alexanderavw

Alexander was fantastic to work with. The project ended up being much more work than either of us expected, but he came up with a great solution and made sure it was working exactly as expected. There was always fast and clear communication from Alexander. Highly recommended.
About the Freelancer
alexanderavw Profile Picture

## BIO 20+ years of experience as programmer. ***Typical implemented projects:*** * desktop applications for data entry (or importing) / processing / reporting (or exporting); connected either to database directly or to server-side components; e-mail sending capability was included in some cases; * web applications - for the same purposes as desktop applications; * server-side applications for implementing business logic and database connectivity tasks; * database design; * solutions based on MS Access and MS Excel; tasks automation in MS Office applications. ***Typical areas of implementation:*** * ordering / sales / accounting; * warehouse management; * freight forwarding management. Besides it some software for scientifical and engineering calculations has been developed University degree in mathematical modelling. Native Russian, fluent Ukrainian and English. ## Area of Expertise ***Platform:*** * Microsoft Windows ***Main programming languages:*** * Visual Basic (VB 6.0, VB.NET, VBA, VBScript) * C++, C# * JavaScript ***Database development:*** * MS Access * MS SQL Server ***Web development:*** * HTML, DHTML, CSS, DOM  * ASP, ASP.NET * client-side scripting, AJAX ***Tools and technologies:** * * .NET * MFC, ATL, STL * OLE, COM, DCOM, COM+ * XML, XSL, DOM * ADO.NET, ADO, DAO, ODBC * Microsoft Reports, Crystal Reports

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • alexanderavw Profile Picture

    alexanderavw

    Kyiv,  Ukraine

    ## BIO 20+ years of experience as programmer. ***Typical implemented projects:*** * desktop applications for data entry (or importing) / processing / reporting (or exporting); connected either to database directly or to server-side components; e-mail sending capability was included in some cases; * web applications - for the same purposes as desktop applications; * server-side applications for implementing business logic and database connectivity tasks; * database design; * solutions based on MS Access and MS Excel; tasks automation in MS Office applications. ***Typical areas of implementation:*** * ordering / sales / accounting; * warehouse management; * freight forwarding management. Besides it some software for scientifical and engineering calculations has been developed University degree in mathematical modelling. Native Russian, fluent Ukrainian and English. ## Area of Expertise ***Platform:*** * Microsoft Windows ***Main programming languages:*** * Visual Basic (VB 6.0, VB.NET, VBA, VBScript) * C++, C# * JavaScript ***Database development:*** * MS Access * MS SQL Server ***Web development:*** * HTML, DHTML, CSS, DOM  * ASP, ASP.NET * client-side scripting, AJAX ***Tools and technologies:** * * .NET * MFC, ATL, STL * OLE, COM, DCOM, COM+ * XML, XSL, DOM * ADO.NET, ADO, DAO, ODBC * Microsoft Reports, Crystal Reports

    ASP, C Programming, Java, and Javascript