0

NL Sheets function not from a table

Jet Reports Historic Posts

January 25, 2013 15:52

None

Follow

Is there a way to use the NL(sheets) function to create sheets based on values that you enter in the formula (not pulling from a table)?

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts January 25, 2013 17:11 Official comment

  Hi!
  
  Yep, absolutely. So if you enter the values you want for the sheets in cells C3, C4, and C5, you could create an NL(Sheets) function like this:
  
  =NL("Sheets",C3:C5)
  This would replicate the value from each cell as a separate sheet. Does this work for you?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts February 25, 2013 15:48

  Thanks Hughes! worked great