Hi All, Good Day ..
I just started learn more about excel deep nowadays, I got promotion in office.
I was assigned to small task in excel, which a am suck now, can anyone just lift me up from this issue.
I have some multiple sheets with dynamic rows to be updated daily
I have 3 sheets with 3 teams data on it and one main sheet(summary) for consolidate, filter all data from other 3 sheets
Sheets data have "date"(date), "name"(text), "site"(text), "shift" (text),"project" (text),"task" (text),"complexity" (text),"hours worked" (number), "notes"(text), all 3 sheets contain these data filled up, and it dynamic(every day it will be updated with new data below it)
The main summary sheet have "From"(date), "To"(date) "name"(text)(drop-down list)
concern:
In summary sheet, when I enter From date and To date, it should filter and do drop-down list all the names in that given dates from all three sheets and remove duplicate, then show the respective results(person) in drop down list in cell B4, when i select that person from list and it should show result in ("task count"(E2), "hours worked"(E3), "leave count"(E4)) and their respective of specific data("date"(date), "name"(text), "site"(text),"project" (text),"task" (text),"hours worked" (number), "notes"(text)) show below.
In summary sheet
Name-B4 Cell: based on two dates, it should load all the names from 3 sheet for those dates and remove any duplicate, and load it in data validation drop-down list
Task Count-E2 Cell: It should count all task done by that person on those specific given dates, some time same person will do two task on same date, so it should count 2 task on that day, should check in all 3 sheets
Hours Worked-E3 Cell: It should sum all total hours worked by that person on those given between two dates, and show the result in number, should check that name in all 3 sheets for that person
Leave-E4 Cell: It should count total number of leaves took by that person on those given between two dates, should check that name in all 3 sheets for that person
When I select the person(drop-down list) from B4, it should show the respective data in "E2""E3""E4" cells
Show Results of that person(drop-down list) selected, which those filtered from above, the cells(A8:G8)(DATE, NAME, SITE, PROJECT, TASK, HOURS WORKED, NOTES)
I am using old version of basic excel 2010, and some time might use online excel 365, (I won't able access for VBA and macros)
so, its better to help me out using only formula will be better.
Thank you all for reading the post and helping me out .
Bookmarks