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 and another mail sheet of summary
I have 3 sheets with 3 teams data on it and one main sheet for summary of all other 3 sheet
Sheet 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)
Question:
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("task" count, "hours worked", "leave count") and their respective of specific data("date"(date), "name"(text), "site"(text),"project" (text),"task" (text),"hours worked" (number), "notes"(text)) show below.
Link: Demo_v01.xlsx
I have attached a sample output format in last image(summary)
Name: based on two dates, it should load all the names from 3 sheet for those dates and remove any duplicate, and load it in drop-down list
Task Count : It should collect all task done by that person on those specific given dates(e.g, 5 , 6, 8), some time same person will do two task on same date, so it should count 2 task on that day
Hours Worked: It should sum all the hours worked by that person on those given between two dates, and show the result in number.
Leave: It should count number of leaves took by that person on those given between two dates
Show Results date of those filtered
We are using old version of excel 2010, and some time we might use online excel 365, (we won't able access for VBA and macros)
so, its better to help me out using only formula will be better.
Link: Demo_v01.xlsx
Thank you all for reading the post and helping me out .
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 and another mail sheet of summary
I have 3 sheets with 3 teams data on it and one main sheet for summary of all other 3 sheet
Sheet 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)
Question:
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("task" count, "hours worked", "leave count") and their respective of specific data("date"(date), "name"(text), "site"(text),"project" (text),"task" (text),"hours worked" (number), "notes"(text)) show below.
Link: Demo_v01.xlsx
I have attached a sample output format in last image(summary)
Name: based on two dates, it should load all the names from 3 sheet for those dates and remove any duplicate, and load it in drop-down list
Task Count : It should collect all task done by that person on those specific given dates(e.g, 5 , 6, 8), some time same person will do two task on same date, so it should count 2 task on that day
Hours Worked: It should sum all the hours worked by that person on those given between two dates, and show the result in number.
Leave: It should count number of leaves took by that person on those given between two dates
Show Results date of those filtered
We are using old version of excel 2010, and some time we might use online excel 365, (we won't able access for VBA and macros)
so, its better to help me out using only formula will be better.
Link: Demo_v01.xlsx
Thank you all for reading the post and helping me out .
