Hi,

I have a set of dates in a columnA.
User is prompted to select a row of these rows (using Inputbox option).
Based on user's selection (suppose Row#7), the values will be copied to a
new columnB retaining First value, Last value and the selected value(row# 7).

Sl # Plan Date ColA

1 24/06/2006
2 01/07/2006
3 08/07/2006
4 15/07/2006
5 22/07/2006
6 29/07/2006
7 05/08/2006
8 12/08/2006
9 19/08/2006
10 26/08/2006
11 02/09/2006
12 09/09/2006

After user selection of row#7, the new column will have the data as below:

Sl # Plan Date ColA

1 24/06/2006
2
3
4
5
6
7 05/08/2006
8
9
10
11
12 09/09/2006

Thanks. Appreciate your help...