Okay I have been needing help on this and I finally got what I have been looking for, the only thing is I can't get the hyperlink to have each sample name individually to show up on Reports sheet cell B1. It does it for 2 sample names and that's it. I want every sample name individually to work, when i click the hyperlink in column AX and AY. I attached a workbook. I have the code in Marco but can't get it to work for every sample in column A.


Attendance Tracker V5 (version 2)sample.xlsm