Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.
I used to be clunky in Microsoft Excel not knowing the most efficient way to do things. That was before I learned some helpful shortcuts. Now I move around my tables super quickly and efficiently.
I have been called the LeBron James of spreadsheets, but I try not to take myself too seriously Growing up in Waterford, south-east Ireland, I was always good at maths. I first used Excel at ...