Excel: Create a master sheet from 10 other sheets.

$15-25 USD / hour

已完成

已发布

大约 5 年前

$15-25 USD / hour

I want to create a roster of everyone in my company. I currently have 10 sheets. Each sheet represents a different area (marketing, finance, etc) and within those sheets are 1-6 tables containing subteams of employees. I'd like to take all of the tables on each sheet and combine them into one Master sheet. However, if the data in a row is edited or a row itself is added/deleted from any of the tables on the 10 sheets, I'd like the Master to reflect that. Additionally, each row (that represents one person) has the months marked that they are contracted for within the tables. I would like to easily be able to filter (by a macro button maybe?) to only show the active employees based on the current month. So if "Table_A" has 10 employees but only 6 of them are contracted in May, if i hit a button it will only show me those 6 contracted in May and filter out the other 4. But if I go to the Master sheet, all 10 employees would still remain of course. I hope that makes sense. I'd be happy to talk through more.

项目 ID: 19605487

关于此项目

10提案

远程项目

活跃5 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@Webxpert4u

Hello, I am ready to combine all 10 sheets into one master according to your needs. I would live to chat before starting. If you can send me all 10 sheets then it would be much easier for me and will be less chat. I would love to do this task by a fixed price instead of hourly. We can discuss and can fix a number. Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for Applications (vba) inside out; writing Microsoft Excel Macros. I can easily create macro to format, compare and merge data from different excel sheets. I can easily create windows desktop app in .NET. LET'S DISCUSS before starting the task. [login to view URL] Excel Login - [login to view URL] Macro Sample- [login to view URL] [login to view URL] Warm Regards

$22 USD 在7天之内

5.0

(303条评论)

8.0

10威客以平均价$20 USD/小时来参与此工作竞价

@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.

$25 USD 在40天之内

4.9

(308条评论)

7.3

@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 projects, i do everything, that's why i only take what interests me and i can do it effectively. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards

$25 USD 在40天之内

5.0

(225条评论)

6.9

@bdoutsource

Hi, Greetings. We need a dynamic dashboard which will summarize all the related tables there (beside master sheet). The master sheet would need to update immediately as soon as any iput update to related fields/tables. We could implement custom reporting by using macros. There lot we can implement to make it more usable. Better if i have the excel file that you already have, i would develop/design based on the data and submit you that you can provide feedback. Plz let me know if you like to discuss more. Thank you.

$15 USD 在40天之内

4.8

(188条评论)

6.6

@younus15

I would also complete your project with the highest precision and quality. I have extensive experience in Excel and Data Processing.

$22 USD 在40天之内

4.9

(107条评论)

5.9

@jasalaz100

I have gone through your job posting and become very much interested to work with you. I am an expert in Excel. I have already completed several projects like this. Can I see your sheets in order to analyze the best way to proceed? I'm looking forward to working with you.

$20 USD 在40天之内

4.9

(32条评论)

4.9

@mingxiao2008

Hello, Dear How are you? I have read your project description and am ready for discussing with you about project. I have experienced in developing Data Entry, Data Processing, Excel, Microsoft Office, Visual Basic. I will work very hard and best for you. Best Regrads

$22 USD 在40天之内

5.0

(5条评论)

5.0

@emilianoreyes70

Hello! Im an excel expert and VBA programming. I figure out something like tihis, you recive the reports (areas), place them in a directory , from the master Sheet you import it (Macro1), build the list/table or check wich has change or new ones . In a report Sheet, filtered fied will shown. Ones the yo have this done its posible to do more like e-mail them, create alarms when someone (register/row) have an maximum of month. etc. Sounds interesting!. Conatct me if you need advice or start work in your proyect. Thanks.

$15 USD 在20天之内

5.0

(1条评论)

2.4

@blakesek99

Hi, I use Excel on a daily basis (both Microsoft and Google Sheets) for tracking investments along with giving good presentations of data. Hopefully I can help

$15 USD 在40天之内