the information from the main sheet ought to now transfer to the 2nd sheet (VBA2), and you may fill the desk in precisely the same manner. suggestion: to pick out a hyperlink with no activating the link to its spot, utilize the arrow keys to pick the mobile which contains the link. , then release the mouse button. You can even utilize the arrow