Excel -Automate update of data fields
$10-30 USD
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.
ID Projekti: #15428079
Rreth projektit
18 profesionistë freelancer dërguan një ofertë mesatare prej $33 për këtë punë
Hi. I can code your Excel tasks. Relevant Skills and Experience Excel, vba Proposed Milestones $55.56 USD - default
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ë
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ë
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ë
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
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ë
5 year experience in this field Relevant Skills and Experience Done government project of same requirement