I have a URL that I am hoping to get text from other cells to merge with.
basically I have a URL
www.myurl.com/yourname=name&yourstate=state
I want to create a form where in Cell A3 they type their name, in cell B3 they type their state. then the url would auto change to
www.myurl.com/yourname=bill&yourstate=TX
I have it so on screen it looks right, but the actual text in the hyperlink never updates, just the visual text does. For example, when I click the "link" it goes to
www.myurl.com/yourname="&A3&" but when I look at the screen before clicking it looks correct... how do I get it so the link is actually clickable using the data that was pulled from the other cells.?
basically I have a URL
www.myurl.com/yourname=name&yourstate=state
I want to create a form where in Cell A3 they type their name, in cell B3 they type their state. then the url would auto change to
www.myurl.com/yourname=bill&yourstate=TX
I have it so on screen it looks right, but the actual text in the hyperlink never updates, just the visual text does. For example, when I click the "link" it goes to
www.myurl.com/yourname="&A3&" but when I look at the screen before clicking it looks correct... how do I get it so the link is actually clickable using the data that was pulled from the other cells.?
