Hello,
I am created a simple macro that allows me:
- Search for a column header in Sheet1
- Go to the first cell underneath that column header
- Copy the value within that cell
- Search for that cell in Sheet2
- Copy the cell location of that value
- Go back to the cell in Sheet1 and hyperlink...