Hi,
Trying to automate a report as much as I can, and the data is all in excel. Currently drawing the number of incidents, etc from another sheet using =COUNTIFS('2025'!$AO6:$AO2000,"7")
All these are automatically turned into graphs etc for use. It all works fine when I am in the office but just want someone to be able to switch one number and it updates automatically.
Is it possible to substitute the 7 in the formula for any number put into J2, so that when J2 is changed to say 8, it the formula will then populate the incident number with week 8's total incidents.
Cheers
Jackson
Trying to automate a report as much as I can, and the data is all in excel. Currently drawing the number of incidents, etc from another sheet using =COUNTIFS('2025'!$AO6:$AO2000,"7")
All these are automatically turned into graphs etc for use. It all works fine when I am in the office but just want someone to be able to switch one number and it updates automatically.
Is it possible to substitute the 7 in the formula for any number put into J2, so that when J2 is changed to say 8, it the formula will then populate the incident number with week 8's total incidents.
Cheers
Jackson