Quote Originally Posted by MarvinP View Post
Hi LawC,

I like what you have done. It looks to me you simply need an autofilter on your data on the Issue Log Tab. Sort the data by Issue Date, old to new, and things seem to work correctly. If that isn't the case, tell me what doesn't still work.

See http://www.contextures.com/xlautofilter01.html for autofilters and tables info.
Thanks for taking the time to check it out, MarvinP.

I just played around with it a bit more, I still have a problem. Here's what happens when I sort (I changed some of the dates for ease of seeing what I'm talking about):

Sorted Data:
1AC1 - AUG 11, 2011
2AB1 - JUN 22, 2011
3FC1 - SEP 11, 2010
4AC2 - SEP 9, 2011
5AC3 - JAN 1, 2008
6FC2 - SEP 11, 2011

Original Data:
1AC1 - JAN 1, 2008
2FC1 - SEP 11, 2010
3AB1 - JUN 22, 2011
4AC2 - AUG 11, 2011
5AC3 - SEP 9, 2011
6FC2 - SEP 11, 2011

The problem is, the way I use my reference numbers, they are changing when I sort. Notice how they still start out: 1, 2, 3, 4, 5, 6? I give those numbers to customers as a reference to look up issues in the future, it needs to somehow stay relevant to the specific issue (almost like a case number). Additionally I currently use that data as my VLOOKUP for the summary sheet.

Thanks again for your efforts!