Excel -Automate update of data fields

Mbyllur Postuar 6 vite mё parё Paguhet në dorëzim
Mbyllur Paguhet në dorëzim

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.

Përpunim të dhënash Excel Excel Macros Excel VBA Visual Basic

ID Projekti: #15428079

Rreth projektit

18 propozimet Projekti në distancë Aktiv 6 vite mё parё

18 profesionistë freelancer dërguan një ofertë mesatare prej $33 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ë
(33 Përshtypje)
5.8
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ë
(33 Përshtypje)
5.6
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ë
(27 Përshtypje)
4.9
awaisjahangir25

A proposal has not yet been provided

$50 USD për 3 ditë
(37 Përshtypje)
5.3
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ë
(25 Përshtypje)
3.9
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ë
(20 Përshtypje)
3.8
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
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ë
(6 Përshtypje)
3.1
mpunn2007

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

$50 USD për 2 ditë
(9 Përshtypje)
3.1
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ë
(4 Përshtypje)
2.8
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
KHACHINA

A proposal has not yet been provided

$15 USD për 2 ditë
(0 Përshtypje)
0.0
prasha44444

i wii do it perfectly

$10 USD për 1 ditë
(0 Përshtypje)
0.0
tuyuansheng2012

A proposal has not yet been provided

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

A proposal has not yet been provided

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