I have 10 persons attendance data monthly wise in 10 sheets. In main sheet i should have a drop down for Moths and in a row i have 10 people names on top of them I have 1 to 31 days. When I select a month in drop down I should get data of particular moth data for whole 10 people.
Month(Drop down)
Date 1 to 30
Names
One
-to-
Ten.
Bookmarks