K
Karl
When we do a project at work, everyone working on the
project has to initial a signoff box in one of five
categories on each sheet of every workbook. It gets
tedious to check to make sure every sheet in every
workbook gets signed off correctly. I wanted to put a
summary page at the front of a workbook that collects this
information.
It would look something like this.
Setup AnalysisCheck Review Sign-off
Sheet1 ABC JKL CCC DEF RRR
Sheet2 ABC JKL CCC FGH RRR
Sheet3 XYZ MNO CCC FGH RRR
The signoff boxes are in different places on each tab but
each signoff is in the same place in the signoff box. I
hoped to name the signoff box on each sheet after the
sheet name and collect them with an index function.
Index(A2,B7,B8)
The index function will work if I read the row and column
number, B7 and B8. But I can't get it to work reading the
name of the range in A2. I tried to use an indirect
function but couldn't get that to work either. Any help
would be appreciated.
project has to initial a signoff box in one of five
categories on each sheet of every workbook. It gets
tedious to check to make sure every sheet in every
workbook gets signed off correctly. I wanted to put a
summary page at the front of a workbook that collects this
information.
It would look something like this.
Setup AnalysisCheck Review Sign-off
Sheet1 ABC JKL CCC DEF RRR
Sheet2 ABC JKL CCC FGH RRR
Sheet3 XYZ MNO CCC FGH RRR
The signoff boxes are in different places on each tab but
each signoff is in the same place in the signoff box. I
hoped to name the signoff box on each sheet after the
sheet name and collect them with an index function.
Index(A2,B7,B8)
The index function will work if I read the row and column
number, B7 and B8. But I can't get it to work reading the
name of the range in A2. I tried to use an indirect
function but couldn't get that to work either. Any help
would be appreciated.