Ditutup

Excel -Automate update of data fields

I havea somewhat large file with many rows of underlying data. On the HRIR tab is my source data with some dummy data to use. I need code to use this data to populate all the other data with the report form I would like to see. I DO NOT WANT formulas sitting in all the tabs. I want my report data to be created by code.

The chart at the bottom of the “Reference” tab has rows that reference the values from previous week and previous month. I would like buttons for each table in the tab, individually, to be update with values from that data that I click the button.

The type of automation I need is in the tabs “SOC 1- 3”, “SOC 4” and so on. I would like a button on the “SPOC” tab to update all of these tabs with the data form the HRIR Data tab. In the HRIR data tab, column BT has data that designate the Employee ID number of each resources manager. The total number of times a manager’s employee id number shows up in this column represents the number of employees that report to this particular manager.

Entries pulled in to SOC 1-3 tab will be those managers who have 1 to 3 employees reporting to them. Entries that show up on SOC 4 tab are managers that have 4 employees reporting to them and so on.

One thing to note is that I would like all new entries on each tab that show up to be highlighted at the top of the list. And a table with each leader’s numbers at that SOC level at the top of each tab.

Summary data for all SOC 1 through 4 will be populated on SPOC tab.

This is all to replace a series of PIVOT tables that are currently populating this file.

Kemahiran: Pemprosesan Data, Excel, Excel Macros, Excel VBA, Visual Basic

Lihat lebih lanjut: data entry on excel, data analysis on excel, bloomberg excel data fields, use excel automate data process, excel automate data monthly, convert large word file data fields excel format, sql update data fields, locking data fields excel, excel script update data, excel macro update existing tabs data main tab, excel script update data connection, excel button update data, excel vba update fields, vba excel import update data, excel vba update imported data, excel automate installation add ins, search data fields mysql database

Tentang Majikan:
( 2 ulasan ) Jersey City, United States

ID Projek: #15428079

21 pekerja bebas membida secara purata $32 untuk pekerjaan ini

zu02

Hi. I can code your Excel tasks. Relevant Skills and Experience Excel, vba Proposed Milestones $55.56 USD - default

$55 USD dalam sehari
(27 Ulasan)
5.6
$25 USD dalam sehari
(87 Ulasan)
5.3
awaisjahangir25

A proposal has not yet been provided

$50 USD dalam 3 hari
(20 Ulasan)
4.4
mohamedrdait

Hello sir I can achieve this project perfectly I can create a vba excel code that will make all the task automatically please contact me for more details Relevant Skills and Experience VBA Excel Proposed Milestones Lagi

$30 USD dalam sehari
(15 Ulasan)
4.1
huongth

Hi. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now Relevant Skills and Experience I am an expert i Lagi

$100 USD dalam 3 hari
(14 Ulasan)
3.4
tom19468

I will modify my existing MS Excel VBA scripts to populate all the other tabs with a button on all “SPOC” tab to update all tabs with the data from the HRIR Data tab. Relevant Skills and Experience I have been coding Lagi

$30 USD dalam 2 hari
(1 Ulasan)
3.4
mpunn2007

. Relevant Skills and Experience . Proposed Milestones $50 USD - ms

$50 USD dalam 2 hari
(6 Ulasan)
2.8
AnilTitusJacob

I have quoted more than your budget. But you will get very good quality work without bugs and delivered on time. Please see my experience and excellent review comments. Relevant Skills and Experience 15 plus years o Lagi

$55 USD dalam 3 hari
(2 Ulasan)
2.7
rIbrarahmed

Concerned, I am skilled and experienced professional. I have 5 to 6 years of working experience in an organization. I feel fit for your project. please feel free to contact with me. Thank you. Relevant Skills and Expe Lagi

$40 USD dalam sehari
(2 Ulasan)
1.9
opsogreen

I have a good skill on excel. So iam interested on this project. Best wishes for you and your project. Relevant Skills and Experience Excel Proposed Milestones $15 USD - Charge

$15 USD dalam sehari
(1 Ulasan)
1.1
akthar0025

Hello Sir I read your requirements and understand very-well and ready to start work from now. Let's discuss more about project in chat. Thank you Relevant Skills and Experience My main skills include: • Data Entry • D Lagi

$15 USD dalam sehari
(3 Ulasan)
0.8
tuyuansheng2012

A proposal has not yet been provided

$25 USD dalam sehari
(0 Ulasan)
0.0
prasha44444

i wii do it perfectly

$10 USD dalam sehari
(0 Ulasan)
0.0
$25 USD dalam sehari
(1 Ulasan)
0.0
Leoagil2017

A proposal has not yet been provided

$35 USD dalam 15 hari
(0 Ulasan)
0.0
KHACHINA

A proposal has not yet been provided

$15 USD dalam 2 hari
(0 Ulasan)
0.0
$25 USD dalam sehari
(0 Ulasan)
0.0
manishraturi55

5 year experience in this field Relevant Skills and Experience Done government project of same requirement

$15 USD dalam sehari
(0 Ulasan)
0.0
$25 USD dalam sehari
(0 Ulasan)
0.0
rizwanahmeddd

I have some experience of excel work Relevant Skills and Experience MS Office Proposed Milestones $20 USD - Automate update of Data Fields

$20 USD dalam sehari
(0 Ulasan)
0.0