Help: Create a sheet and cycle through years and months with out needing more then one sheet

[steve89]

hello everyone first i know this is possible Excel has a template if you search "Employee Attendance Tracker 1" on the excel sheet (not online) and you'll find that your able to change the year on this calendar and somehow all the data from the previous year pulls back up if you return back to 2017 and if you go to a new year all the data from 2017 is gone. My goal is to not need workbook after workbook for different years of employee attendance. Currently i have a sheet where all the months are on different sheets but i also would like all the months in one sheet but using only a drop down function as seen in the "Employee Attendance Tracker 1" template same fir the year. I don't want multiple sheets just one sheet for the years data and one for the month.

i have a sheet now and its almost done and wouldn't mind sending it but not sure how so everyone can reference my question.

 

[steve89]

so here's the breakdown:

its an attendance sheet

F1 = drop down list for employee names
J4 = year that were on (but i want to change this year and have previous year information)

A 12:A24 EQUALS MONTHS

B 12 = VACATION =VLOOKUP($F$1,January!$AH$10:$BD$106,3,FALSE)
C 12 = HOLIDAY =VLOOKUP($F$1,January!$AH$10:$BD$108,6,FALSE)
D 12 = SICK =VLOOKUP($F$1,January!$AH$10:$BD$108,4,FALSE)
E 12 = PERSONAL =VLOOKUP($F$1,January!$AH$10:$BD$108,5,FALSE)
F 12 = BIRTHDAY =VLOOKUP($F$1,January!$AH$10:$BD$108,7,FALSE)
G 12= BEREAVEMENT =VLOOKUP($F$1,January!$AH$10:$BD$108,8,FALSE)
H 12 = FMLA =VLOOKUP($F$1,January!$AH$10:$BD$108,9,FALSE)
I 12 = JURY DUTY =VLOOKUP($F$1,January!$AH$10:$BD$108,10,FALSE)
J 12 = MISSED PUNCH =VLOOKUP($F$1,January!$AH$10:$BD$108,11,FALSE)
K 12 = EARLY PUNCH =VLOOKUP($F$1,January!$AH$10:$BD$108,12,FALSE)
L 12 = LATE =VLOOKUP($F$1,January!$AH$10:$BD$108,13,FALSE)
M 12 = ABSENT =VLOOKUP($F$1,January!$AH$10:$BD$108,14,FALSE)
N 12 = NO CALL NO SHOW =VLOOKUP($F$1,January!$AH$10:$BD$108,15,FALSE)
O 12 = NO BREAK TAKEN =VLOOKUP($F$1,January!$AH$10:$BD$108,16,FALSE)

i would like to go to J4 change the year and the previous year information is there and if i go to 2018 then there no data because nothing has been added