Hello everyone, this is my first post so i apologize in advanced for any lack of forum format to my thread.
I don't really have much experience on VBA, just did a begginers course online and i still feel really lost. Therefore, i'll try to explain my idea as basic and possible and adapt it later to my huge excel file as a mission to learn. :D
I've been trying to create a macro that updates links on a specific file with name "Mother File A" from "Example File B" to "Example File C".
I want cells A3:A8 which are populated with Example File B links to be copied and pasted to cell B3:B8 and link updated with Example File C.
Excel 2016
This is a really simple process to do manually, but this file has several different sheets with lots of links.
Hope this thread helps more than me!
Thanks!
I don't really have much experience on VBA, just did a begginers course online and i still feel really lost. Therefore, i'll try to explain my idea as basic and possible and adapt it later to my huge excel file as a mission to learn. :D
I've been trying to create a macro that updates links on a specific file with name "Mother File A" from "Example File B" to "Example File C".
I want cells A3:A8 which are populated with Example File B links to be copied and pasted to cell B3:B8 and link updated with Example File C.
Excel 2016
This is a really simple process to do manually, but this file has several different sheets with lots of links.
Hope this thread helps more than me!
Thanks!