Lukket

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.

Evner: Dataindførsel, Databehandling, Excel, PHP, Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 4 bedømmelser ) Aberdeen, United Kingdom

Projekt ID: #16241437

30 freelancere byder i gennemsnit £441 på dette job

£500 GBP in 21 dage
(74 bedømmelser)
8.4
£500 GBP in 5 dage
(282 bedømmelser)
7.3
£300 GBP in 3 dage
(265 bedømmelser)
7.7
cugamelover

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 Flere

£250 GBP in 7 dage
(206 bedømmelser)
7.2
P0L

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 dage
(238 bedømmelser)
6.9
elqueabandona

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 dage
(189 bedømmelser)
6.7
Wonderer

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 dage
(73 bedømmelser)
6.3
asin1987

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 Flere

£555 GBP in 10 dage
(51 bedømmelser)
6.1
katilinas

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 dage
(111 bedømmelser)
6.3
workerbee1974

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 Flere

£833 GBP in 10 dage
(17 bedømmelser)
5.6
£250 GBP in 10 dage
(35 bedømmelser)
5.4
whitehorsetechn

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 Flere

£500 GBP in 4 dage
(18 bedømmelser)
5.1
beltran0404

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

£250 GBP in 3 dage
(79 bedømmelser)
5.0
katiewells3

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 Flere

£555 GBP in 10 dage
(19 bedømmelser)
4.7
periyannas

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 Flere

£600 GBP in 4 dage
(27 bedømmelser)
4.6
vmadhavan15

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

£500 GBP in 10 dage
(14 bedømmelser)
4.1
£500 GBP in 15 dage
(10 bedømmelser)
4.1
£250 GBP in 4 dage
(6 bedømmelser)
3.6
laurajiannaras

Hello again, I placed a bid for the first project you posted that did not include the user access specifications. I hope you're the same person, as there are many frauds on this site. I have read and understand t Flere

£400 GBP in 6 dage
(6 bedømmelser)
3.7
only1ls

although my bid (negotiable) is higher, the quality of the spreadsheet will be professional and I'll get it done asap. please message me to discuss the project in detail. thank you for considering me Advanced Excel Flere

£500 GBP in 4 dage
(4 bedømmelser)
3.4