-1

Jet Professional GP - NL Sheets from company selection

Tyler Linke

August 21, 2017 12:26

None

Follow

Good morning,

I have a company lookup setup in the report options to select companies to run report for.  I'd like to build a tab for each company using NL Sheets but when I select multiple companies it can't build the sheets.

I think it's stemming from the multi selection feeding into the NL Sheets as "xxx|yyy|zzz" but it wants a range of cells or an array in form "xxx","yyy","zzz".

Any way to do this using the selection "xxx|yyy|zzz"?

Thanks!

• Facebook
• Twitter
• LinkedIn

2 comments

• -1
  
  Sarah Kloser August 23, 2017 02:20

  Hi Tyler,

  Just saw this. Do you have to use a range of cells for the company names? Please see my response to your other post.

   

• 0
  
  Tyler Linke August 23, 2017 11:35

  Yep works awesome! Didn't see my first post go through so posted a second. Thanks!