Add userform to excel spreadsheet
- or -
Post a project like this1919
£44(approx. $55)
- Posted:
- Proposals: 8
- Remote
- #2250607
- PRE-FUNDED
- Awarded
Excel and VBA expert. Professional OCR. PDF to Excel Conversion. Data management, Translations English Russian
Hua Hin
Excel VBA, MS PRoject Expert, Web Scraper, Arena, Simulation, Spreadsheet, Wordpress customisation
Istanbul
Data entry/Data extraction/Data scraping/Web research/Web scraping/Excel expert/Data analysis/Excel data entry/Virtual assistant/Admin support/Content writing/Blog writing/Ecommerce product listing
Kolkata
Data Entry, PDF Conversation, MS word, Ms excel, Transcription, Web research, PDF fillable Form, Mail Merge Expert
Jaipur
11046301300449171158619467872195169249017425140532518037
Description
Experience Level: Entry
The spreadsheet attached is the look of how I want the spreadsheet to function. However I want this to go to users and therefore it needs to be customisable by the user.
I want a userform to be added to the spreadsheet and this will collect information from the user.
The userform need to collect the following information
1. Company name - this should be inserted into cell A1 when the userform is closed after the words ‘Costs of running’
2. Number of employees – this should then add/delete columns starting in column D. i.e. the number of columns should match the number of employees entered on the userform. There should be a minimum of 1 columns (employees) and a maximum of 10 (employees)
3. Collect a % number. At this stage I want that number available to me as I haven’t created the formula. This should be between 1 and 100.
The orange cells are input boxes for the user.
The grey cells calculations.
The user should be able to call up the userform at anytime and make changes which are immediately reflected on the spreadsheet.
The whole spreadsheet should be protected so the user can’t access or change it apart from inputting the orange cells.
I want a userform to be added to the spreadsheet and this will collect information from the user.
The userform need to collect the following information
1. Company name - this should be inserted into cell A1 when the userform is closed after the words ‘Costs of running’
2. Number of employees – this should then add/delete columns starting in column D. i.e. the number of columns should match the number of employees entered on the userform. There should be a minimum of 1 columns (employees) and a maximum of 10 (employees)
3. Collect a % number. At this stage I want that number available to me as I haven’t created the formula. This should be between 1 and 100.
The orange cells are input boxes for the user.
The grey cells calculations.
The user should be able to call up the userform at anytime and make changes which are immediately reflected on the spreadsheet.
The whole spreadsheet should be protected so the user can’t access or change it apart from inputting the orange cells.
Gary R.
100% (21)Projects Completed
22
Freelancers worked with
20
Projects awarded
47%
Last project
6 Oct 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies