View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lancastergeneral[_2_] lancastergeneral[_2_] is offline
external usenet poster
 
Posts: 1
Default copy row when matching colums found


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

--
lancastergenera
-----------------------------------------------------------------------
lancastergeneral's Profile: http://www.officehelp.in/member.php?userid=549
View this thread: http://www.officehelp.in/showthread.php?t=128461

Posted from - http://www.officehelp.i