Excel: Dynamic Sub Tables Based On Master Sheet

종료 등록 시간: 4년 전 착불
종료 착불

I have a company roster (the Master sheet) that contains about 20 columns of data for each employee (about 450 employees). I have additional tabs for each Functional Area (Tabs: Marketing, Finance, Etc. - 9 total) that the employees are in, as identified in the Master Sheet. Those 9 tabs contain varying amount of tables for each team that make up that Functional Area. I would like to have those tables dynamically change if the Master Sheet has any edits, deleted rows, or added rows. Each Functional Area has anywhere between 1 and 8 tables of teams, that would need to be added to dynamically change, with a varying amount of people/records on each team.

This video tutorial is essentially what I want. The only difference is that each tab would have several different tables, to represent and organize the different teams within those Functional Areas. You do not have to do it the same way this video instructs, if you know a better way, but just adding for reference.

[login to view URL]

I would also like to future-proof the document, so that it would be possible to add new teams (tables) or new functional areas (Tabs) as necessary.

I have a spreadsheet I can share for reference that has the Master sheet, and all of the different Tabs and Teams as an example, that I am currently manually updating on both the Master Sheet and the individual tabs.

엑셀 비쥬얼 베이직 데이터 처리 데이터 입력 마이크로소프트 오피스

프로젝트 ID: #20102330

프로젝트 소개

45 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 4년 전

이 일자리에 대한 프리랜서 45 명의 평균 입찰가: $191

cgullapalli

HI, I am good at Excel and VBA. I can achieve it through the vba and filtering process. Pretty quick for any any number of rows and number of tables. Please share the file to review the number of tables in each t 기타

$250 USD (1일 이내)
(901 리뷰)
8.0
ponnarasiBabu

I am an excel expert and have completed many complicated excel related tasks. Can provide you sample if required of my past and current work. Read the project specs. Looks like this project is feasible. Just want to un 기타

$250 USD (7일 이내)
(427 리뷰)
7.5
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application to generate and delete sheets automatically. I plan to use a 기타

$200 USD (7일 이내)
(253 리뷰)
7.5
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$200 USD (3일 이내)
(361 리뷰)
7.5
zekovicm

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and youtube video and that's perfect fit for my skills ! Check out my profile and former clients feedb 기타

$190 USD (4일 이내)
(153 리뷰)
7.5
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje 기타

$250 USD (5일 이내)
(244 리뷰)
6.9
shoguna2m

Hi there, My name is Mauricio I'm the MS Excel expert from Trascender Global Team, with 4 years of experience in working with Excel data, optimizing the data handling and also creating VBA coding. I've read the deta 기타

$223 USD (4일 이내)
(139 리뷰)
7.2
avinav606lx

Hello there, This looks feasible and I can do this quickly. Can you share your excel files? I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 기타

$250 USD (4일 이내)
(176 리뷰)
6.5
rashedkhanrubel

Hi, I have read the project description & i want to make dynamic table & chart for this project. I am experienced to work with table & graph. I will fulfill your requirement as oer video. Please send a massage so we ca 기타

$100 USD (3일 이내)
(111 리뷰)
5.6
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, 기타

$200 USD (3일 이내)
(34 리뷰)
5.8
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry, excel

$177 USD (5일 이내)
(103 리뷰)
6.2
vsprybhanu

Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio 기타

$120 USD (3일 이내)
(99 리뷰)
5.7
abhinovpankaj

Hello, I have been working as freelancer since last ~ 6 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications 기타

$240 USD (10일 이내)
(62 리뷰)
5.5
Mickelson

⭐ Hi, sir ⭐ I have looked carefully at your commentary. In my view, I think I am the right person for your project. I have deep knowledge and a lot of experience with vba in excel. I can automate the process which is 기타

$200 USD (2일 이내)
(13 리뷰)
5.2
sevillajk01

hello! let me help you! I have seen the video and I am very confident that I can help you with it. I offer high quality and accurate output with a reasonable bid amount. Hope you will consider me, thanks.

$150 USD (4일 이내)
(30 리뷰)
4.6
gsanggara

Hi There, I am excel expert freelancer an very interested to your project. I have take alook the youtube video link provided I can automate your current manual process and create dynamic sub table based on master tab 기타

$150 USD (1일 이내)
(28 리뷰)
4.2
techism

Hi There, trust that you are having great time. Let me ensure that a simple change on master sheet will automate the data sets in whole workbook, and it will be done in no time. I hope to get this project and trust me 기타

$100 USD (3일 이내)
(14 리뷰)
3.6
sharifemran420

I sow your project description in details. I understand your requirement. I think I can full-fill your project. I am ready to start these jobs. I can delivery this in advance time with 99% accuracy. I never convince yo 기타

$100 USD (7일 이내)
(11 리뷰)
3.4
TAP1990

Hi, I´ve built multiple files just like the one you´re describing. I can fix your file without any trouble. In order to proceed I´d need a skype meeting to make sure we´re aligned in terms of deliverables. Once the cal 기타

$388 USD (7일 이내)
(1 리뷰)
1.6
swapnildhake

After watching video I would propose a macro based workbook to perform required actions. Can you please check excel file in my portfolio, "sample dashboard" (use item number p10010-p10020 to search). You can enter an i 기타

$250 USD (6일 이내)
(2 리뷰)
1.3