Hi guys, first time poster here hoping to get a bit of help on a problem. I have a workbook with four sheets similar to this format:
Sheet1
SampleA1
SampleA2
SampleB1
SampleB2
SampleC1
SampleC2
Sheet2
ID Date
A1 Date1
A2 Date2
Sheet3
ID Date
B1 Date3
B2 Date4
Sheet4
ID...