If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Summary Sheet
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. |
#2
|
|||
|
|||
Summary Sheet
Hi Karl,
Why not use something simple like =Sheet!A1 ? Biff -----Original Message----- 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. . |
#3
|
|||
|
|||
Summary Sheet
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. -----Original Message----- Hi Karl, Why not use something simple like =Sheet!A1 ? Biff -----Original Message----- 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. . . |
#4
|
|||
|
|||
Summary Sheet
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 -----Original Message----- 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. -----Original Message----- Hi Karl, Why not use something simple like =Sheet!A1 ? Biff -----Original Message----- 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. . . . |
Thread Tools | |
Display Modes | |
|
|