Find Jobs
Hire Freelancers

Need Excel Template Manipulated for Data Entry By Others

$10-30 USD

Completato
Pubblicato circa 6 anni fa

$10-30 USD

Pagato al completamento
I need to make sure I have controls in place for an Excel Template that will be used for gathering data. What I want is: 1. I want the macros to automatically apply and be running once the file opens – force the macros to apply upon opening 2. I want the drop down data selection for High Level function to automatically apply the applicable data selections in the drop down for Function1 Column (see references tab) 3. If I pick a Function Role in column V, the High Level Function 1 and Function1 in columns W and X should automatically be populated with the mapping in the references tab. Also, the High Level Function 2 and Function 2 should be cleared out. 4. If Functional Role is empty, the drop downs should be available for columns W and X on High Level Function and Function. People should be able to select high level function and function, even if there is no functional role. However, if there is a selection for a cell in column V made, any data in the corresponding cells for columns W and X, high level function and function, are cleared, and filled in with instead the exact values (possibly on v lookup) of the appropriate high level function and function from the mapping in the reference tab.
Rif. progetto: 16340203

Info sul progetto

18 proposte
Progetto a distanza
Attivo 6 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
Hello, I've done many small projects like this one in Excel and Access for my own job. I completed what you asked already as a way to stay sharp in my skills. I love scripting and visual basic. Unfortunately, there is no way to force a workbook to enable macros upon opening. This would be a major flaw for hackers to exploit easily. However, a user can change their settings to always enable macros for workbooks and never be prompted after one initial time. I do have a question though. If someone selects something in Column W, should the X column be limited as well? I would be happy to provide support after completion as well (free of charge, provided it's minor changes). Thanks!
$20 USD in 1 giorno
4,8 (1 valutazione)
0,6
0,6
18 freelance hanno fatto un'offerta media di $35 USD
Avatar dell'utente
- Based on the pick of Functional Role, the high level function 1 and Function1 can be populated. - Drop downs could be based on the respective function, and the function roles as in References tab. - Have done similar dynamic role based drop down, where the first drop down selection determines the subsequent drop down values.... it was Role hirerarchy. - Please see my profile for some of high complex projects done earlier. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - Stocks Portfolio - Showing client portfolio stocks with various indicators, Momentum indicators based on portfolio. - University, US - Scoring the answer sheets based on keyword and number of occurences.
$150 USD in 3 giorni
4,6 (51 valutazioni)
6,1
6,1
Avatar dell'utente
I have a large experience working with advanced Excel and Macros using VB, the most important thing is that I can do the job, quickly and well done. Please, contact me and let's talk about how I could help for your project.
$25 USD in 2 giorni
5,0 (15 valutazioni)
3,8
3,8
Avatar dell'utente
Dear Customer . i understand your requirement and will Provide sample work within 1 hours. trust me and Hire me . I have complited many data analytical work high quality and accuracy last five year. i can start now your project according to the your guide line with Confirmation.
$15 USD in 1 giorno
4,9 (12 valutazioni)
3,6
3,6
Avatar dell'utente
STATISTICAL ANALYST Economist and Macroeconomic Analyst. Specialty on labor economics research and statistical analysis. Hard working, fast-learning, excellent logical and analytical skills. - Proficiency: Economics, Labor Economics, Demographics, Microeconometrics. 1) Time Series Analysis and Forecasting (ARIMA); 2) OLS, IV, Tobit and Logistic Regression; 3) Panel Data Analysis, Fixed Effect & Random Effect Models, - Programming: STATA, Excel/VBA, R and Matlab
$20 USD in 2 giorni
5,0 (1 valutazione)
1,7
1,7
Avatar dell'utente
WE NEED THIS PROJECT TO DO WE HAVE TEAM WITH MT HANDS IF ANY WORK WE CAN DO AS PER GUIDELINE S GIVEN BY YOU
$28 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
I will finish this project within the time period.I have excelled in this software and can finish the work
$25 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A proposal has not yet been provided
$29 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
I have 8+ years of Experience in Web, Windows, Windows Phone and Dynamics AX. Technology with VB.NET, C#, ASP.Net, WPF, HTML5, Java Script, CSS, Bootstrap, Visual Basic 6.0 ,Macro VBA, SQL, access, Excel, SSRS, SSIS, Crystal Report. I have strong background in building scalable, predictable, high-quality and high-performance knowledge In the Microsoft technology
$45 USD in 8 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Good knowledge in excel and VBA macros and have relavant experience in handling this type of projects very easily.
$13 USD in 1 giorno
5,0 (1 valutazione)
0,1
0,1
Avatar dell'utente
• Excellent verbal and written communication skills. • Good keyboard & internet knowledge. • computer data entry operator
$25 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A proposal has not yet been provided
$25 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
I already finish your request and can now be subject for your testing. I have basic to advance knowledge in developing Excel/ Excel Macro projects.
$12 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED STATES
Jersey City, United States
4,2
6
Metodo di pagamento verificato
Membro dal ott 27, 2011

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.