I'm looking to get a worksheet that will lookup & retrieve data from multiple sheets/tabs within one excel file. This will require multi-sheet & multi-column lookup with conditions with a return from a corresponding column. Summary page would need mulitple drop down menus for the search condition, date range selection, totals for a condition, a percentage caluculator, and also a filter for the employee's name or number.
Summary page would filter by a Work Order type "SC", date range range of 9/1/19 thru 9/2/19, total hours for Work Orders coded as "SC", total hours for the returned value for the "SC" Work Orders divided by the total hours for that date range, and also a filter for an employee name - John Doe.
65 freelancers are bidding on average $115 for this job
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thank you, Asad Khan
I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I have a few question to discuss so I need you to send a message on chat.