Hi all,

I'm trying to connect two worksheets in a way that keeps everything linked together when the main (#1) worksheet is sorted.

In the first worksheet, I have FirstName/LastName/ID/other basic info, and in the second worksheet I have FirstName/LastName/ID/Dates of visits.

The second worksheet has Dates of visits manually added in each time someone visits and it goes across (along the row). What I'm trying to do is to make the 2nd worksheet pull the first 3 columns (FirstName/LastName/ID) from worksheet #1. The problem is after doing that, if I sort the first worksheet after adding new people, the 2nd worksheet pulls the new names but the dates don't sort with the names leaving all the links broken.

Mainly, I'm trying to be able to use the dates of visit to find the most recent visit, # of visits, and # of visits within certain time periods. Those functions I've already set up but the linking issue is giving me a headache. My last resort is to put it all on one worksheet but I'm trying to avoid that to keep the first worksheet as clean and simple as possible.

Thanks.