I'd like to create an excel sheet that allows for several mini-sheets to feed into one master-sheet on a dynamic basis.
Master sheet will also have 2 types of filtering methods, 1. A type in filter. 2. A drop down filter
1- each manager enters his subset grades
2- the managers extend the rows of each grade subsets according to the number of the subsets they have.
3- the manager needs a drop down filter on his own sheet to find the people he has entered.
4- all the information which has entered in all sheets have to be shown automatically on a mastersheet. In mastersheet, there are drop downs for searching people's name, job families, job titles.
37 freelancers are bidding on average $118 for this job
Hi, I'm a excel expert in the area and I would love to help you in the process of getting your job done! please feel free to ask any questions about my experience.
I am highly proficient in excel analysis , with over six years experience. I am an expert in excel automation , vba and data analysis. I'll deliver the desired output in the shortest time possible.
Hi there, I have really good typing speed as well as advanced excel and word skills. I’m a responsible person can provide the work before deadline with high accuracy. Thanks
I have Certificates Microsoft Office "MOS" in Office PowerPoint 2010,Office Access 2010,Excel Expert 2010 and I've been working in Visual Basic for over 7 years now