autonaming of lookups when using multiple modules

range namesLookup Tables
2 posts / 0 new
Last post
Samantha Myers X 0
SM
autonaming of lookups when using multiple modules

Hey!

I am new to this forum and hoping someone could help me and explain how to do something with the software. 

Basically. When I insert multiple asset modules into my model and customize them, say for assets at cost, fair value and capitalized bank fees, the autoprefix on my lookup tables are always LU_Asset_1, LU_Asset_2 etc.

I want to make this more logical and relevant to the module so rather than 1,2,3... they say Cost, FV, Fees etc. For example. LU_Asset_Cost, LU_Asset_Fees etc. 

I have tried changing the prefix manually but it doesnt impact the lookups. I would like for it to be so that the autoprefix doesnt use 1,2,3 etc. 

 

Thank you

Samantha

 

James Longden A+ 103

Hi Samantha.  I think you might be looking for is the prefix of the module?

If you go into the Project Manager, and select the module in question (shown below for a second Asset module), then under the properties, change the prefix to something more suitable. In the below, I've changed this to "Fees".  You should be able to see how the range names all update automatically?

Note: it won't change from LU_Asset_Capex to LU_Asset_Fees but from LU_Asset_Capex to LU_Fees_Capex, which I believe is what you're after?

The alternative is changing the module names using the Name Manager (Formulas tab) but this is more manual and less comprehensive than the above.  Have a play and let me know if it's worked in the way you'd like.  Images below.  Cheers.  J.