Mbyllur

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.

Aftësitë: Përpunim të Dhënash, Excel, Excel Macros, Excel VBA, Visual Basic

Shihni më shumë: 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

Rreth Punëdhënësit:
( 2 përshtypje ) Jersey City, United States

ID e Projektit: #15428079

21 freelancer dërguan ofertën mesatare $32 për këtë punë

zu02

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

$55 USD pёr 1 ditë
(27 Përshtypje)
5.6
$25 USD pёr 1 ditë
(87 Përshtypje)
5.3
awaisjahangir25

A proposal has not yet been provided

$50 USD për 3 ditë
(20 Përshtypje)
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 Më shumë

$30 USD pёr 1 ditë
(15 Përshtypje)
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 Më shumë

$100 USD për 3 ditë
(14 Përshtypje)
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 Më shumë

$30 USD për 2 ditë
(1 Përshtypje)
3.4
mpunn2007

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

$50 USD për 2 ditë
(6 Përshtypje)
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 Më shumë

$55 USD për 3 ditë
(2 Përshtypje)
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 Më shumë

$40 USD pёr 1 ditë
(2 Përshtypje)
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 pёr 1 ditë
(1 Përshtypje)
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 Më shumë

$15 USD pёr 1 ditë
(3 Përshtypje)
0.8
tuyuansheng2012

A proposal has not yet been provided

$25 USD pёr 1 ditë
(0 Përshtypje)
0.0
prasha44444

i wii do it perfectly

$10 USD pёr 1 ditë
(0 Përshtypje)
0.0
$25 USD pёr 1 ditë
(1 Përshtypje)
0.0
Leoagil2017

A proposal has not yet been provided

$35 USD për 15 ditë
(0 Përshtypje)
0.0
KHACHINA

A proposal has not yet been provided

$15 USD për 2 ditë
(0 Përshtypje)
0.0
$25 USD pёr 1 ditë
(0 Përshtypje)
0.0
manishraturi55

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

$15 USD pёr 1 ditë
(0 Përshtypje)
0.0
$25 USD pёr 1 ditë
(0 Përshtypje)
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 pёr 1 ditë
(0 Përshtypje)
0.0