L
lancastergeneral
hi everyone
i am new to excel programming. your help will be useful to me.
i hava a table i want to match date in cloum one with the date which
just entered. if both dates match copy matching date's row in to ne
sheet. here is the sample data.
thank you in advance.
lancaster_general
Enter today date:_________
date p1 p2 p3 p4 p5
12/12/2006 1 2 3 4 5
12/13/2006 2 3 4 5 1
12/14/2006 3 4 5 1 2
12/15/2006 4 5 1 2 3
12/16/2006 5 1 2 3
i am new to excel programming. your help will be useful to me.
i hava a table i want to match date in cloum one with the date which
just entered. if both dates match copy matching date's row in to ne
sheet. here is the sample data.
thank you in advance.
lancaster_general
Enter today date:_________
date p1 p2 p3 p4 p5
12/12/2006 1 2 3 4 5
12/13/2006 2 3 4 5 1
12/14/2006 3 4 5 1 2
12/15/2006 4 5 1 2 3
12/16/2006 5 1 2 3