Hi guys
Not sure if that was discussed before, looked at forum and at learning stuff, didn't find it.
So what I am trying to do - I have a price list of items, some of those are duplicated deliberatly - different price bands, and the strucutre of this list will change in the future - new items added, new price bands and so on. This one is one of my categories block. The other list I want to have and use further among with the previous one is the list of the same items without duplicates. I know how to do the list of unique items, so it's not a issue, unless there's some specific way in Modano to add it - please let me know. So as you can imagine the second list should change as well when there are new items in the first one. Can Modano do it automaticcaly or I need to play with VBA to do it?
If I do it via VBA - is it ok to have that as a Excel.Range in the code and adjust it accordingly - wouldn't it cause any interference with Modano if I add it programmatically?
Another questions - I have noticed that in Modano I can not add range names without links to the worksheets, which I use a lot for all the constants (e.g. strEmpty = " ", strDot = ".", iONE = "=1", iMILLI = "=10^-3" and so on). However it's still doable via VBA. Can it cause any issues in the future?
Thanks for your help