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

copy row when matching colums found
 

please help me on thi

--
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

copy row when matching colums found
 

Maybe you can just use =vlookup()???

Debra Dalgleish has some notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())

lancastergeneral wrote:

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 i
just entered. if both dates match copy matching date's row in to new
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 4

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

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

--

Dave Peterson

copy row when matching colums found
 

thank you very much. i use vlooku

--
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