Forum Discussion
Purchase Requisition: Use hyperlink to autofill address cell
Hi, I saw this in an example online, but cannot find information on how to duplicate it.
I am creating a purchase request, and I want to have the option to click on a hyperlink that is connected to a cell containing our company address and have it auto populate that information in another cell when the hyperlink is clicked. I know I am going to need a VBA for this, but I am completely unfamiliar with VBA as of yet. The other solutions I have found are overcomplicated and involve larger amounts of data and sorting. I just want this one cell. This isn't a must have, more like a super cool feature and would be nice to have.
https://doctorsvolunteerclinic-my.sharepoint.com/:x:/g/personal/anisa_volunteerclinic_org/EbWF2AisgsZIrCLwHJBXTicB3LA24sBAbIVd2hTftGQRQw?e=JKRfBa