Need Excel Template Manipulated for Data Entry By Others
$15-25 USD / hora
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.
Nº del proyecto: #16349270
Sobre el proyecto
15 freelancers están ofertando un promedio de $19 / hora por este trabajo
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered ten excel vba projects in the past two months. Willing to take up your project. Thank you, Regards.
Greeting, I have understood your Need Excel Template Manipulated for Data Entry By Others task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experienc Más
Good Day!!! This is my first project, i will done as your requirement. I have good knowledge of MS Excel and MS word. ⦁ Wrote a multitude of Excel VBA scripts and queries. ⦁ Automation Template Creation by Exce Más
my smart and hard work with past experience of managing excel files, preparing word documents, makes me eligible for this job
I want to earn money Relevant Skills and Experience Question paper typing in school and college Notice typing Etc
With over 6 years of work experience into Designing/Automation and Execution of Reports, MIS and dashboards. I have a proven track record of translating stakeholder requirements into tangible deliverable taking respons Más
good in excel and vba macros to handle this type of projects with accuracy and timely delivery with 100% satisfaction.
Hi, I would love to showcase my previous excel project over TeamViewer, where I have handled similar requirements as yours. Thanks for your time and consideration.