Need Excel Template Manipulated for Data Entry By Others

$10-30 USD

Opravljeno

Objavljeno

pred približno 6 leti

$10-30 USD

Plačilo ob dostavi

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.

Visual Basic for Apps

ID projekta: 16340203

Več o projektu

18 ponudb

Projekt na daljavo

Aktivno pred 6 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@rmseverson

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 v 1 dnevu

4,8

(1 ocena)

0,6

18 freelancerjev je oddalo ponudbo s povprečno vrednostjo $35 USD za to delo

@satishtl

- 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 v 3 dneh

4,6

(51 ocen)

6,1

@lherreraz

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 v 2 dneh

5,0

(15 ocen)

3,8

@Nicecreator

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 v 1 dnevu

4,9

(12 ocen)

3,6

@tiagobarreira

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 v 2 dneh

5,0

(1 ocena)

1,7

@Kamalakar1985

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 v 1 dnevu

0,0

(0 ocen)

0,0

@mohamedsybudeen

I will finish this project within the time period.I have excelled in this software and can finish the work

$25 USD v 1 dnevu

0,0

(0 ocen)

0,0

@vcallegarip

A proposal has not yet been provided

$29 USD v 1 dnevu

0,0

(0 ocen)

0,0

@mrjoshiomtech

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 v 8 dneh