Summary Sheet

[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.

 

[Karl]

That's not going to help. The signoff box could be
anywhere on a given sheet. I don't know what cells they
will be in.

 

[Biff]

Hi Karl,

I don't know if this is much better:

Name the 5 cells of the signoff box that contain the
initials as Signoff1,Signoff2,Signoff3,etc corresponding
to that particular sheet.

On the summary page in the the signoff box select the 5
cells that correspond to sheet1. In the formula bar enter
this formula as an array:

=IF(Signoff1="","",Signoff1)

And repeat this formula for the other sheets substituting
the appropriate Signoff(n).

Biff