Excel: Create a master sheet from 10 other sheets.

$15-25 USD / hour

Fullført

Lagt ut

omtrent 5 år siden

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

Prosjekt-ID: 19605487

Om prosjektet

10 forslag

Eksternt prosjekt

Aktiv 5 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

Tildelt til:

@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 om 7 dager

5,0

(303 omtaler)

8,0

10 frilansere byr i gjennomsnitt $20 USD/time for denne jobben

@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 om 40 dager

4,9

(308 omtaler)

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 om 40 dager

5,0

(225 omtaler)

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 om 40 dager

4,8

(188 omtaler)

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 om 40 dager

4,9

(107 omtaler)

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 om 40 dager

4,9

(32 omtaler)

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 om 40 dager

5,0

(5 omtaler)

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 om 20 dager

5,0

(1 omtale)

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 om 40 dager