Write some Software
$250-750 USD
Pagado a la entrega
An excel spreadsheet needs to be developed with advanced VBA, macro and userforms.
1- The user will interact with a multi tab userform to fill, view, modify, add, delete, and print equipment specifications, without any interaction with excel sheets
2- There will be a sheet with data in the background ... looking at about 100 columns, and flexible number of rows (to be added or removed by the user - there is an initial list with 300 row items in it, however the developer is expected to add 10 items only, to prove that the system works, and the user will add the rest of rows). The rows are equipment numbers, and the columns are specifications for each equipment.
3- The system will work in following order:
- Once developed, the file will have ~100 columns with specifications loaded.
- The user will open the excel file - a multi tab userform will open - The user will not see the background data / sheets
- There will be a "Search - drop down" menu (like an interactive phone book - or like google search) to find the equipment number (which will be listed in column A) and pull the data from the corresponding row - The user should have the option to add an equipment if it is not found - Adding an equipment will add a row to the database - Removing an equipment will delete a row from the database - editing a row will edit a row in database
- Once the user selects the equipment they need, the latest information saved in the database will be displayed for each specification (from the columns) - Some of the information will be checkboxes (boolean), some will be text and some will be numbers
- The user will be able to modify the information and update the data in database, which will be saved as the latest version and will be displayed when the userform is opened in future - The whole idea of this tool is to keep the latest data available, and provide the user with an output.
- Once the user is satisfied with the information, they will be able to click a box and save the file as pdf in a specified folder, or print it directly.
- pdf extract will include all information in a nicely formatted sheet , and will have the option to attach other "pdf, word, jpg, excel" files to be printed together with the printout - This option is required for the user to be able to browse, select a file from a directory, and include it in printout.
- The file will be saved.
4- Some of the features that will be required for the system:
- Drop downs, checkboxes, text boxes
- Cascade checkboxes
-----------------------------------------------------------------------------------------
I have drafted a simple version of the tool that I can share with you, after I review your profile and offer.
Nº del proyecto: #10940826
Sobre el proyecto
24 freelancers están ofertando un promedio de $525 por este trabajo
Dear Project poster, I have 5 years of experience. I have good knowledge of excel and visual basic. Price is not a concern for me. I am looking for projects. Let me give an opportunity to work. We can talk further w Más
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. They speak for themselves. Best rega Más
I have close to 15 years of experience in a wide spectrum of automation projects involving both hardware and software. For personal reasons, I have taken a break from my job now. In my career, I have written automatio Más
Hello, My name is Chris and, as you can see from my profile, i have 15+ years experience working with Excel/VBA and 13+ years teaching them both (all levels). All specifications are clear to me, my only point is the Más
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SEO, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y Más
I am an expert in delivering custom scripts and look forward to discuss more details about the project
I have the expertise and experience in Excel & scripting in VBA and can do this project, quickly and accurately, as per specification. Ready to start work immediately.
Dear Sir or madam, I would like to go on every step one by one and clear the details. I am pretty new to freelancer.com but i just finished an excel work can be similar to tis. I ope to hear from you. Have a nic Más
Hello, Dear, how are you? VB is my main skill! Because i am a certified developer with 10-years experience developing with VB. I'm very glad to know that there is a suitable task for me in this freelancer. I Más
We have done ample of Data Entry, Macro, Dashboards, Database, Designing projects which can automate your work very easily and make your work attractive. Below of below points I can say you can choose us : 1 - We Más
Dedicated to work and able to deliver result in time. Highly experienced in developing UI using Excel VBA. Developed various user forms, custom control, triggering, validation, user interaction, error handling. User a Más
Hello, I am new to Freelancing but I do have high expertise and more than 8 years of professional experience in Data Analysis & building MS Excel Macros. I believe I can cater to your requirement. I have create Más