Hey, I'm creating a workbook for archery events (enrolment and results). I have one sheet for enrolment, one for preliminary shootings and one for finals. The entire setup for the finals are predefined.
During the shooting (between each final) the setup for the finals has to be "published" so the shooters can see who their going to meet next (and then they are all waiting for me to finish the setup for the next round).
I do one class at the time and use autofilter. Before I print the setup I have to change the heading (in cell A2). I often forget this and print the correct setup with the wrong class-name and get a lot of sour comments.
What I like to do is to "automagicaly" change the displayed value (class name) in cell A2 based on the class name in column C in the filtered list, but I don't know how to do this with a textstring. If it had been a number I would have used SUBTOTAL. Can anyone tell me how this can be done?
Thanks in advance!
Regards
Asbjørn Søbye
During the shooting (between each final) the setup for the finals has to be "published" so the shooters can see who their going to meet next (and then they are all waiting for me to finish the setup for the next round).
I do one class at the time and use autofilter. Before I print the setup I have to change the heading (in cell A2). I often forget this and print the correct setup with the wrong class-name and get a lot of sour comments.
What I like to do is to "automagicaly" change the displayed value (class name) in cell A2 based on the class name in column C in the filtered list, but I don't know how to do this with a textstring. If it had been a number I would have used SUBTOTAL. Can anyone tell me how this can be done?
Thanks in advance!
Regards
Asbjørn Søbye