0

NL Summary Page

Jet Reports Historic Posts

July 29, 2008 16:15

None

Follow

I have developed a report that creates a new sheet for each department that i want, and it gives me the information i want for each department.

now, Iam using JET functions to give me the values i need, but in cell N52 (on each sheet), it is strictly an excel calculated field. I add up a couple Jet formula, and the result is cell N52.

But, on the summary sheet, i have used an NL to give me a list of the departments, and what i want right beside each department is what is in cell N52.


Here is my NL for giving me the list of departments for my summary page.
NL("Rows","Dimension Value","Code","Dimension Code","DEPARTMENT","Code",Options!$C$48)

Now all i want right beside it, is what is in cell N52 for each department (sheet).

Any ideas?

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts July 29, 2008 17:24

  You should look at the Excel INDIRECT() function.
  
  http://support.microsoft.com/kb/213933
  http://www.contextures.com/xlFunctions05.html
  
  assuming that cell D6 contains
  =NL("Rows","Dimension Value","Code","Dimension Code","DEPARTMENT","Code",Options!$C$48)
  
  then in cell E6,
  =INDIRECT(D6&"!N52")

• 0
  
  Jet Reports Historic Posts July 29, 2008 20:13

  This worked !!!!!!
  
  Thanx Chuck

• 0
  
  Jet Reports Historic Posts July 30, 2008 12:06

  INDIRECT is a nice function for this, in combination with "ADDRESS" and "ROW", "COLUMN", it's very usefull for summary sheets…