Đã Đóng

Excel: Dynamic Sub Tables Based On Master Sheet

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.

Kĩ năng: Excel, Visual Basic, Xử lí dữ liệu, Nhập liệu, Microsoft Office

Xem nhiều hơn: cnet excel working pivot tables, excel macro compare tables, excel macro cut paste based cell value, excel dynamic chart, html based inventory exel sheet, web developer data charts excel dynamic, dynamic sub domain creation aspnet, flash dynamic image swap based size, excel dynamic front end, excel macro charge fee based time, create sheets excel using master sheet, user excel dynamic tables net, dynamic web template based master page, excel based labour time sheet, excel master sheet, build a dynamic web page based on input data provided, complete pdf forms based on excel data file, Freelancer are charge a sliding fee based on your lifetime billing with each clients, based on excel

Về Bên Thuê:
( 2 nhận xét ) Orlando, United States

ID dự án: #20102330

47 freelancer đang chào giá trung bình $190 cho công việc này


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Thêm

$300 USD trong 4 ngày
(708 Nhận xét)

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 Thêm

$250 USD trong 1 ngày
(881 Nhận xét)

Hello, I am ready to write codes in excel file so all tables dynamically change if the Master Sheet has any edits, delete or add rows. Can we discuss in details before starting? Highly experienced in Excel Programming Thêm

$250 USD trong 5 ngày
(304 Nhận xét)

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 Thêm

$250 USD trong 7 ngày
(423 Nhận xét)

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 Thêm

$200 USD trong 7 ngày
(211 Nhận xét)

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 Thêm

$190 USD trong 4 ngày
(133 Nhận xét)

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 trong 3 ngày
(310 Nhận xét)

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 Thêm

$250 USD trong 5 ngày
(226 Nhận xét)

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 Thêm

$223 USD trong 4 ngày
(106 Nhận xét)

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 Thêm

$250 USD trong 4 ngày
(175 Nhận xét)

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom f Thêm

$194 USD trong 10 ngày
(91 Nhận xét)

Hi, I am interested in your proposal and I am ready to solve your task. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These are screenshots of so Thêm

$150 USD trong 3 ngày
(78 Nhận xét)

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, Thêm

$200 USD trong 3 ngày
(32 Nhận xét)

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 trong 5 ngày
(103 Nhận xét)

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 Thêm

$240 USD trong 10 ngày
(62 Nhận xét)

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 Thêm

$120 USD trong 3 ngày
(83 Nhận xét)

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 trong 4 ngày
(26 Nhận xét)

⭐ 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 Thêm

$200 USD trong 2 ngày
(10 Nhận xét)

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 Thêm

$150 USD trong 1 ngày
(25 Nhận xét)

Hi, How are you today? I have just read your job description carefully and I am very interesting in your job. I am a senior Excel,VBA,C,C++ ,C# developer with 10 years experiences and I have developed many program of u Thêm

$200 USD trong 3 ngày
(10 Nhận xét)