I hope I'm in the right place. I have a workbook that contains 4000 rows. In one sheet, I have a field that is populated by a reference to another sheet (i.e.- =OtherSheet!G345) The 1st sheet is a summary sheet, and the 2nd is a detail sheet. I had set up individual hyperlinks the hard way... one at a time. Now the data has changed and I need to modify the hyperlinks. On the example of =OtherSheet!G345, the hyperlink would need to point to OtherSheet!H345. This seems simple as it could be, but I'm too stupid to figure it out. Has anyone done this? I've found a bunch of VBA to change static directories, but can't seem to modify them to fit this case. Thank you.