I am trying to see if it is possible to have a macro edit itself in a permanent way. From what I have found on the internet it is potable to do something with the macro but I am unsure if I can do something more permanent.
The Idea is this.
I have a list my MACRO follows to determine who will be assigned a ticket number based on customer number. However if the customer is new then the MACRO will automatically select a person from the list to permanently add the customer to. I can do this with a separate spreadsheet being used for the list but I would rather hard-code the list into the MACRO and then add the new customer numbers to the hard-coded list so it is there for the next time the MACRO is ran.
This will prevent the need for a 2nd spreadsheet and removing the need to make sure the 2nd spreadsheet is in the correct folder and named properly. Cutting out the 2nd sheet all together feels like a better option.
I imaging I can do this with an Array so my question becomes:
Is it possible to use the MACRO to edit a hard-coded Array within the MACRO permanently so the new values are in the Array on the next time the MACRO is ran.