I have a worksheet called Timeline that will be used to record various dates for 250 customers. On my second worksheet, I need to pull the names and dates from the Timeline worksheet. The customer name and corresponding date from the Timeline worksheet only need to display on my second worksheet if there is a date entered. The second worksheet needs to have the ability to be sort by the name or date. Also, new names may be added to the Timeline worksheet so my second worksheet needs to be updated accordingly.
I figured out how to pull the data from the Timeline worksheet but I can't get the second worksheet to have the ability to sort.
Here is what I have come up with:
[code]
IF(AND(IF(ISBLANK(INDEX(Timeline!$C$15:$IZ$15,ROW())),"",INDEX(Timeline!$C$15:$IZ$15,ROW())))>=DATEVALUE(“01/01/2011”)*AND (IF(ISBLANK(INDEX(Timeline!$C$15:$IZ$15,ROW())),"",INDEX(Timeline!$C$15:$IZ$15,ROW())))<=DATEVALUE(“12/31/2011”)), (IF(ISBLANK(INDEX(Timeline!$C$15:$IZ$15,ROW())),"",INDEX(Timeline!$C$15:$IZ$15,ROW()))), “”)
[end code]