0

Create sheets with fixed word added

Johan van der Wal

September 19, 2017 14:05

None

Follow

How do I create sheets with a fixed word like "Items" appended to it.

 

I now have:

=NL("Sheets";"Salesperson Purchaser";"Code";"Code";$F$3;"DataSource=";"DWH-2013")

This adds a sheet for each sales person code, but I would like to add Items to it.

Is that possible?

Thanks for your help.

• Facebook
• Twitter
• LinkedIn

5 comments

• 0
  
  Harry Lewis September 19, 2017 14:20

  Hello Johan -

  Try this:

  NL("Sheets";"Salesperson Purchaser";"=NF(,""Code"")&"" Items""";"Code";$F$3;"DataSource=";"DWH-2013")

   

• 0
  
  Johan van der Wal September 19, 2017 14:41

  Hi Harry,

   

  Thanks for your quick reponse.

  The code gives back an error.

  Could not eveluate =NF(,""Code"")&"" Items"""

  Johan

• 0
  
  Harry Lewis September 19, 2017 17:28

  My apologies; I'm accustomed to US format:

   

  NL("Sheets";"Salesperson Purchaser";"=NF(;""Code"")&"" Items""";"Code";$F$3;"DataSource=";"DWH-2013")

• 0
  
  Johan van der Wal September 20, 2017 07:27

  Hi Harry,

   

  Sorry to say, but I still get an error.

  

  Thanks,

   

  Johan

• 0
  
  Harry Lewis September 20, 2017 13:50

  Sorry Johan.

  It just occurred to me that the name of your data source implies that it is a data warehouse.  The technique I provided only works with a Dynamics NAV data source.