Hi All,
I am using a formula to count how many times a name appears in an individual sheet using:
=COUNTIF('2209'!H1:H50,"A Name")*12
which is placed on a seperate sheet and then timsing it by 12 as the staff member works 12 hours.....
This works well but a new sheet is created weekly (time sheets for staff) with the name of the sheet being the date of the last working day of that week IE: sheet name: 2710 would be the sheet name so i would know that specific weeks ends on that date.
what i want to do is be able to get the formula to autoupdate every time i create a new sheet so when 2710 becomes 0311 the fomula will change automatically from =COUNTIF('2710'!H1:H50,"A Name")*12 to =COUNTIF('0311'!H1:H50,"A Name")*12
I tried adding a date box at G2 so i could just type in say 0311 so i tried changing the formula to =COUNTIF('=G2'!H1:H50,"A Name")*12 so it would add the content of g2 and in turn reference that sheet name but i had no luck with this.
Can anyone suggest a way to make this work? apologies as you can tell i am a noob so make it idiot friendly please lol
Bookmarks