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

終了済み 投稿 6年前 着払い
終了済み 着払い

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.

データ入力 情報処理 エクセル PHP ビジュアルベーシック

プロジェクトID: #16241437

プロジェクトについて

27個の提案 リモートプロジェクト アクティブ 6年前

27人のフリーランサーが、平均£456 で、この仕事に入札しています。

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 もっと

£555 GBP 10日以内
(185件のレビュー)
7.5
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 5日以内
(292件のレビュー)
7.2
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 7日以内
(225件のレビュー)
6.9
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 もっと

£250 GBP 7日以内
(214件のレビュー)
7.2
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 11日以内
(124件のレビュー)
6.6
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 10日以内
(73件のレビュー)
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 もっと

£833 GBP 10日以内
(24件のレビュー)
6.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. もっと

£250 GBP 3日以内
(119件のレビュー)
5.4
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 もっと

£555 GBP 10日以内
(26件のレビュー)
4.9
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. もっと

£500 GBP 10日以内
(28件のレビュー)
5.0
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 もっと

£500 GBP 4日以内
(20件のレビュー)
5.4
Sercho56

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 もっと

£500 GBP 7日以内
(11件のレビュー)
4.6
K9JT

Hi I just bid recently on your previous project post for the same project. I understand the security requirements, and can implement them as well. Please PM me so we can chat if you need more assurance. As for th もっと

£250 GBP 10日以内
(14件のレビュー)
3.2
Overseashelp

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 10日以内
(3件のレビュー)
3.3
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 もっと

£500 GBP 4日以内
(4件のレビュー)
3.4
vijay3699

Hi, I can do the needful and design an application which will match your requirement. I am VBA developer with 8 years of experience in designing tailor made application to various clients. I completely understood y もっと

£722 GBP 10日以内
(0件のレビュー)
0.0
sebring2006

Hello, I am an experienced MS Access developer, proficient in excel. I designed, developed and implemented many end user systems, combining Access-Front End and MS Excel reports for different clients and different in もっと

£555 GBP 10日以内
(0件のレビュー)
0.0