Find Jobs
Hire Freelancers

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

£250-750 GBP

Cerrado
Publicado hace alrededor de 6 años

£250-750 GBP

Pagado a la entrega
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.
ID del proyecto: 16241437

Información sobre el proyecto

27 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
27 freelancers están ofertando un promedio de £456 GBP por este trabajo
Avatar del usuario
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 once. I work on one project at a time, so my full devotion will be towards your job only. Please give me one opportunity. Thanks and Regards, Ash
£555 GBP en 10 días
5,0 (185 comentarios)
7,5
7,5
Avatar del usuario
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 en 5 días
4,9 (292 comentarios)
7,2
7,2
Avatar del usuario
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 en 7 días
5,0 (225 comentarios)
6,9
6,9
Avatar del usuario
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, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/
£250 GBP en 7 días
4,8 (214 comentarios)
7,2
7,2
Avatar del usuario
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 en 11 días
5,0 (124 comentarios)
6,6
6,6
Avatar del usuario
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 en 10 días
5,0 (73 comentarios)
6,3
6,3
Avatar del usuario
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 access. My passion is building Custom Access Databases. I have built well over 250 custom databases in the past 16 years. I have taken all classes from beginner to expert 97 to 2013. I can send working samples on request. Some of the databases I have built include Production, Inventory, Scheduling, time-clock, Book-Keeping, facilities management, and many custom databases I am bidding on your project because I feel my experience and education has prepared me well for it. My strong desire to become one of the best in my field is my motivation to excel as an Access Developer and I would appreciate the opportunity to put my skills and experience to work for you. What you get if you allow me to do your project. The Database to your vision. I will create the database and continue to change upon your input until it is what you in vision. I will offer lifetime support for the database; I will give all my contact information if chosen to complete your Project. I if there are any bugs or issues to the original Database I will fix free of charge. Thank you for your time.
£833 GBP en 10 días
4,7 (24 comentarios)
6,1
6,1
Avatar del usuario
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. Please contact me by chat then we I could know when do you need this done! Kind regards, Luis Romero
£250 GBP en 3 días
5,0 (119 comentarios)
5,4
5,4
Avatar del usuario
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 particular subject matter expertise, and have created similar registers in the past. I know you have mentioned you don't want users asking what is required, however I would like to chat further about how much security you need around the lowest level user. Even if the data table sheets are all hidden in Excel when in this permission level they would still be able to be referenced via formulae or someone writing a macro in a second workbook. Access could be an option here to improve the security (so at worst case a malicious user could only view the data they have submitted), however it still wouldn't be perfect. From reviewing your project description and the supplied sheet my understanding of the work you are after is as follows: 1. Create data entry forms for all registers / data flows / audits which can be used to submit data to the relevant list 2. Add 3 tiers of user permissions to the sheet, with a user log-on as the first process (once logged on move to the menu form) 3. Add the VBA to automate the entire process
£555 GBP en 10 días
5,0 (26 comentarios)
4,9
4,9
Avatar del usuario
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. will check the attached excel files also.. Please ping me once you are happy with my proposal.
£500 GBP en 10 días
4,9 (28 comentarios)
5,0
5,0
Avatar del usuario
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 experience in Data Entry, Data Processing, Excel, PHP, Visual Basic
£500 GBP en 4 días
4,8 (20 comentarios)
5,4
5,4
Avatar del usuario
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 Excel that use Macros to limit the users ability to play with things. I can even incorporate input validation if required, so that the input data meets whatever input requirements you have (e.g. I can ensure that valid date values are entered into date fields to prevent your database from being corrupted by bad data). I will work with you to achieve your exact solution, and will happily make changes to the final product to meet your requirements, providing they are not adding new features outside the scope of your posted project (e.g. colours, placement, formatting are fine, but adding a new function would not be within the quoted price). Just for your info, I have created similar projects for a Dance School, who wanted a GUI for entering student record information and class signups. I have also developed an extensive GUI for an Aviation organisation who required a training program around student and aircraft availability. Happy to discuss the project via private chat if you want prior to awarding the project. Obviously, I would relinquish the rights to all written code upon payment.
£500 GBP en 7 días
5,0 (11 comentarios)
4,6
4,6
Avatar del usuario
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 the previous project post, I think you can just close the project. Not sure why you are not able to delete it as employers regularly do that. Kind regards John
£250 GBP en 10 días
5,0 (14 comentarios)
3,2
3,2
Avatar del usuario
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 en 10 días
5,0 (3 comentarios)
3,3
3,3
Avatar del usuario
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 skills, Advanced VBA skills, Advanced Macro skills, C# programming, Computer programming, SQL programming
£500 GBP en 4 días
4,9 (4 comentarios)
3,4
3,4
Avatar del usuario
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 your requirements and i will design the solution in less than a week looking forward.
£722 GBP en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 industries. From your detailed explanation and provided excel sheets I understand what you need. I would suggest MS Access database with reports in excel as a better solution than excel only. I already have created some similar projects with custom security and encrypted passwords. Login ID can be created within database or I can use Windows login ID if each user has own account on the PC, whichever way works for you. If we proceed this way you will need to specify what data should be exported in excel reports. In report form you will be able to select what report to export or select period for report, etc… If you need, we may record all the changes done by the user on any form. In case you decide to go this way or if you want to discuss this further and in more details please contact me. I am confident that I can perform job effectively and I would be happy to make myself available for this project. Sincerely yours, Rad
£555 GBP en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Aberdeen, United Kingdom
4,7
4
Forma de pago verificada
Miembro desde oct 19, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.