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.
Bu iş için 65 freelancer ortalamada $115 teklif veriyor
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.
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.
I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Daha Fazla