Forum Discussion
Named Range Column Changed
Activate the September sheet
Change the definition of SeptName to
=INDEX($A$2:$Z$100, 0, MATCH("Author's Name", $A$1:$Z$1, 0))
That of SeptCat to
=INDEX($A$2:$Z$100, 0, MATCH("Competition Title", $A$1:$Z$1, 0))
And of SeptScore to
=INDEX($A$2:$Z$100, 0, MATCH("Score", $A$1:$Z$1, 0))
Similar for the other sheets (activate each in turn).
Do the sheets have descriptive headers in row 1, for example "Cat", "Name" and "Score"?
Row 1 in each sheet shows column headers - Cat is "Competition Title", Name is "Author's Name" and Score is "Score". There are many other columns but those are the only that I get data from.
Charlene
Activate the September sheet
Change the definition of SeptName to
=INDEX($A$2:$Z$100, 0, MATCH("Author's Name", $A$1:$Z$1, 0))
That of SeptCat to
=INDEX($A$2:$Z$100, 0, MATCH("Competition Title", $A$1:$Z$1, 0))
And of SeptScore to
=INDEX($A$2:$Z$100, 0, MATCH("Score", $A$1:$Z$1, 0))
Similar for the other sheets (activate each in turn).
