Let me simplify my question:
1) On Sheet 1 I have 3 client names with data corresponding with them. There are multiple entries on different dates for these clients
2) On next sheets 2-4 i want to sort the data of the three clients i.e. John, Joe, and Jack.
3) If for example on sheet 3 row 1, i am looking for Client John, on Sheet 1 Row 1 it doesn't have John, I want it to search for the next row John's name was enetered on the first Sheet
Thanks for any help
This message was edited by redsalt on 2002-11-06 08:58
1) On Sheet 1 I have 3 client names with data corresponding with them. There are multiple entries on different dates for these clients
2) On next sheets 2-4 i want to sort the data of the three clients i.e. John, Joe, and Jack.
3) If for example on sheet 3 row 1, i am looking for Client John, on Sheet 1 Row 1 it doesn't have John, I want it to search for the next row John's name was enetered on the first Sheet
Thanks for any help
This message was edited by redsalt on 2002-11-06 08:58