I'm using the Option sheet to select which companies I want to build sheets for. Any way to use that selection in NL(Sheets)?
Output of the selection is "xxx|yyy" but NL(Sheets) wants an array form "xxx","yyy". I'm not referencing a field from a table so feel I need to use an array.
Any ideas? Thanks!
Using Jet Professional for GP
Hi Tyler,
You can nest an NP(Companies) function to do what you are looking for. (If I understand what you are trying to do that is...)
In case you didn't know, NP(Companies) creates an array of company names.
I can't seem to figure out how to attach the example so I will spell it out here.
1. I created an NL(Lookup) to select which companies to run the report for.
=NL("Lookup",NP("Companies"),"Select a Company")
2. On the section sheet, I have an NL(Sheets) function that creates a sheet for each company selected from the report options.
=NL("Sheets",NP("Companies",Options!$C$2))
You can filter your companies just like any other filter set.
I hope this is what you were looking for!
SLK
Works awesome. Thanks!