The excel has 31 worksheets with daily report for everyday. I need someone to make a master sheet which gives summation of all 31 sheets in one Master sheet. I need a dropdown for date. After I select date from the dropdown, I should be able to get the sum of all sheets till that date.
Master sheet needs to have following columns:
Column A,B,C,D,E,F - picked up as it is
Column G- Sum
Column H- Count of yes
Column I- Count of Yes
Column J- Sum
Column K,L,M,N,O,P,Q,R,S,T,U- Sum
Column V- Not required
Column W- as on that date which has been selected.