Hi there,
I have a tricky situation. I have around 600 table arrays in a speadsheet that I must rename with specific GUIDS that I have. I know the technical way of going to Formulas-->Define Names-->Name Manager-->Selecting the table I want to rename and than entering the new name. Would anyone know of a way to do this that would help me from not having to do it manually? Some form of a vlookup..? Maybe a macro?
I have a tricky situation. I have around 600 table arrays in a speadsheet that I must rename with specific GUIDS that I have. I know the technical way of going to Formulas-->Define Names-->Name Manager-->Selecting the table I want to rename and than entering the new name. Would anyone know of a way to do this that would help me from not having to do it manually? Some form of a vlookup..? Maybe a macro?