xcel - use macro's, buttons & forms to control data entry.

First off, do not bid unless you have reviewed and understood the requirements (sick of people putting in bids then asking what is required!), your initial bid will be taken as and indication you have read and understood the requirements.

Looking for a simple solution that uses a GUI to allow users to simply navigate to input forms within a spreadsheet by using one worksheet as a main menu and allowing the user to click a button to navigate to a data input screen for the particular tab. Therefore, I need the workbook to open directly onto a "main menu worksheet" displaying the buttons to the user relating to each tab within the workbook. User presses relevant button, is taken to input form to allow data entry, on completion of data entry, presses button to save to save input, presses another to return to main menu, to exit spreadsheet and save all changes, user presses an exit worksheet button. All the above it very simple project for excel, vba, .net etc. type coder.

What I am also looking for is a bit so security as follows:-

1. There should be Three levels of user, 1, superadmin (can view actual worksheets and modify the main menu macros etc. full control), 2. Admin, can view worksheets and enter data directly into them, cannot modify columns, titles etc. 3. Standard user, can only see main menu and input forms.

2. On opening the workbook the user should be asked for a username and password. If an Admin username and password is entered, the admin is taken to the main menu as all other users would be, however, all the tabs of the workbook are displayed, allowing them to move between and enter date into them. An additional worksheet will have usernames and passwords and access rights e.g. admin, normal user. Anytime admin adds a user to this part of the spreadsheet a new user is created with associated rights.

3. If a non-admin user logs in, then they will only be displayed with the main menu and data entry worksheets, in other words they cannot go directly to the work sheet view. work displayed allowing them to view the actual worksheets. I can do it myself but do not have the time. Example spreadsheet attached.

4. The user "standard" should not be able to move cells, only press buttons.

You may prefer to transfer this to an MS access DB solution? Your call.

Don’t bit unless you understand the requirements and can see it through.

Cannot delete the existing project, Rent a Coder was so much better!

Thanks for your interest.

Skills: Data Entry, Data Processing, Excel, PHP, Visual Basic

See more: excel macro that inserts data with a button, excel data entry form examples, how to create a data entry form in excel 2016, data entry form in excel free download, excel data entry form with drop down list, data entry in excel worksheet, how to create a data entry form in excel using vba, excel vba data entry form download, critical control data entry, control data entry formats with input masks, engagement of project managers and data entry operator on contract basis last date to rech for region state, list of data entry company in new zealand, data entry projects in new zealand, data entry operator vacancies new delhi delhi, data entry clerk on monster com, companies looking for data entry clerks on line, wpf ribbon control data entry application, forms fill data entry, easy online forms filling data entry, forms daily data entry

About the Employer:
( 4 reviews ) Aberdeen, United Kingdom

Project ID: #16241437

28 freelancers are bidding on average £449 for this job

£500 GBP in 21 days
(75 Reviews)

Dear Employer, I have read your requirement and all the three points about the users and their hierarchies. I am clear about your job and if given a chance, I will do your job. Request you to please check my reviews More

£555 GBP in 10 days
(165 Reviews)
£300 GBP in 3 days
(266 Reviews)
£500 GBP in 5 days
(289 Reviews)

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

£500 GBP in 5 days
(281 Reviews)

I can do exactly what you need using Excel VBA. I'm a computer professional with and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macr More

£250 GBP in 7 days
(212 Reviews)

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

£500 GBP in 7 days
(217 Reviews)

Hello, I'm ready to work on "data entry macro 's" project. Relevant Skills Excel, VBA Milestones 359 GBP - code writing 89 GBP - userfriendly interface I can achieve the results that you are asking for.

£449 GBP in 11 days
(122 Reviews)

Hello I've read your requirements. All is clear. Can show you samples of similar projects done in the past (for UK companies) Cheers Valery

£555 GBP in 10 days
(73 Reviews)

Clear with requirements and Nice to know your requirement. I am an excel vba, vb6 expert and have delivered eight excel vba projects in the past one month. Willing to take up your project. I will do it as an excel vba More

£600 GBP in 4 days
(80 Reviews)

I have read and understand the project, I would suggest Microsoft access not excel. Excel is a great tool, However when you get to large it can become a large mess. If you have Microsoft professional you have Microsoft More

£833 GBP in 10 days
(23 Reviews)

Greeting, I have understood your xcel - use macro's, buttons & forms to control data entry. task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experie More

£500 GBP in 4 days
(20 Reviews)
£250 GBP in 10 days
(44 Reviews)

Hello, I am Luis from Venezuela and I have understood your requirements for users and requirements for excel workbook. I can help you develop this excel solution through macros for you according to your premises. More

£250 GBP in 3 days
(113 Reviews)

I am a technical business analyst with 15 years of professional experience working with Excel, VBA, Access, and SQL Server. I have also worked extensively in privacy compliance (albeit here in Australia), so have parti More

£555 GBP in 10 days
(25 Reviews)

I am not a random bidder... I have 14+ years of exp with various project exposure.. I hope I can do this one. Please ping me if you are interested with my proposal and thank you. I have read the project details fully. More

£500 GBP in 10 days
(23 Reviews)
£500 GBP in 15 days
(13 Reviews)

I will use the same methodology as I have done in the past to build the user rights and access restrictions you want. I have a significant amount of experience developing working, easy-to-use, and efficient GUIs for E More

£500 GBP in 7 days
(9 Reviews)
£250 GBP in 4 days
(6 Reviews)

hello, i am interested in your project. i can help you create a 3 levels access spreadsheet that will allow users to login and manipulate data according to their access level. waiting to hear from you, thank you

£388 GBP in 10 days
(3 Reviews)