Hello all!
This is my first ever post on MrExcel, so please be gentle with me regarding VBA and Macros since this is all still pretty new to me.
Ok, so I would like to know whether the following is possible with VBA and how I should go about doing it since I have yet to find an answer but it will probably be easy for you guys! This would really add some efficiency to my day if there is a way of making this a macro.
I am trying to create dynamic hyperlinks that alter based on 4 digit numbers entered inside cells within a single column. In other words, the beginning of the URL always remains the same, but the last four digits are the part that changes (i.e. example.com/id-xxxx). So that when a 4 digit number is then added into a cell, the cell subsequently becomes a hyperlink to that unique ID.
How would I go about creating this?
Many thanks in advance!
This is my first ever post on MrExcel, so please be gentle with me regarding VBA and Macros since this is all still pretty new to me.
Ok, so I would like to know whether the following is possible with VBA and how I should go about doing it since I have yet to find an answer but it will probably be easy for you guys! This would really add some efficiency to my day if there is a way of making this a macro.
I am trying to create dynamic hyperlinks that alter based on 4 digit numbers entered inside cells within a single column. In other words, the beginning of the URL always remains the same, but the last four digits are the part that changes (i.e. example.com/id-xxxx). So that when a 4 digit number is then added into a cell, the cell subsequently becomes a hyperlink to that unique ID.
How would I go about creating this?
Many thanks in advance!
