Ditutup

Need Excel Template Manipulated for Data Entry By Others

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.

Kemahiran: Excel, Excel Macros, Pemprosesan Kata

Lihat lagi: excel template website data entry, need template survey data entry, excel macros forms data entry, excel auto populate data from one worksheet to another, google spreadsheet data entry form, create a form to populate an excel spreadsheet, complex excel spreadsheet examples, create a form as a worksheet in excel that adds records to another worksheet, spreadsheet skills resume, advanced excel spreadsheet templates, spreadsheet skills checklist, excel skills needed data entry work, excel front end data entry access, need typing job asap data entry job asap, creating excel template importing data, spreadsheet template contact data entry, excel copy paste data entry, excel web allow data entry, need excel macro input data, create excel template import data

Tentang Majikan:
( 0 ulasan ) farooqnagar, India

ID Projek: #16349270

17 pekerja bebas membida secara purata $19/jam untuk pekerjaan ini

whitehorsetechn

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 Lagi

$15 USD / jam
(10 Ulasan)
4.5
chintuag

Dear Hiring Manager, I have worked on various automation projects in excel using macros. My expertise in Excel includes, but not limited to: Macros, Web Scraping, User Forms, Pivot Tables, Formulas, Customized Ri Lagi

$23 USD / jam
(8 Ulasan)
4.0
periyannas

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.

$25 USD / jam
(15 Ulasan)
4.1
$15 USD / jam
(12 Ulasan)
3.2
mehranrana1990

A proposal has not yet been provided

$20 USD / jam
(0 Ulasan)
0.0
venkat5652

good in excel and vba macros to handle this type of projects with accuracy and timely delivery with 100% satisfaction.

$15 USD / jam
(1 Ulasan)
0.1
harishgada

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 Lagi

$15 USD / jam
(0 Ulasan)
0.0
$22 USD / jam
(0 Ulasan)
0.0
priyom1499

I want to earn money Relevant Skills and Experience Question paper typing in school and college Notice typing Etc

$16 USD / jam
(0 Ulasan)
0.0
pablor88

A proposal has not yet been provided

$22 USD / jam
(0 Ulasan)
0.0
seemaseema26

my smart and hard work with past experience of managing excel files, preparing word documents, makes me eligible for this job

$22 USD / jam
(0 Ulasan)
0.0
$17 USD / jam
(1 Ulasan)
0.0
Marine7

A proposal has not yet been provided

$22 USD / jam
(0 Ulasan)
0.0
$22 USD / jam
(0 Ulasan)
0.0
lampcagriya

Hope you are fine! We are Web and Mobile Application development company providing solutions to our customers. We are serving 110 countries with 16000+ customers globally. For detailed information about our serv Lagi

$22 USD / jam
(0 Ulasan)
0.0
UmayapandiM

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 Lagi

$15 USD / jam
(0 Ulasan)
0.0
raviindore

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.

$15 USD / jam
(0 Ulasan)
0.0