Hi All,
Im wondering if any of you out there can help me create a vb script that does the following:
displays the first and last dates associated with an account number found in a range of account numbers.
If in sheet 1 of an .xls workbook:
Column A Column B
Account Number: Date:
100000 1/1/2005
100000 1/1/2004
100000 1/1/2003
200000 1/1/1980
200000 1/1/1982
300000 1/1/1981
Sheet 2:
If an account Number is typed in Column A in sheet 2, it populate the oldest and newest dates in the appropriate cells in Column B and C that match the account number in sheet 1. Where: If there is only one date, then it treates the only date as the oldest date and the newest date would = "NO ADD HIST"
Column A Column B: Column C:
Account Number: Oldest Date: Newest Date:
100000 1/1/2003 1/1/2004
300000 1/1/1981 NO ADD HIST
Thanks in advance for your help
David Kim
UBS Global Asset Management
299 Park Ave.
New York NY 10171