[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

copy row when matching colums found

lancastergeneral

12/12/2006 4:24:00 PM


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.off.../member.php?u...
View this thread: http://www.off.../showthread.php...

Posted from - http://www.off...
3 Answers

lancastergeneral

12/15/2006 5:51:00 PM

0


please help me on this


--
lancastergeneral
------------------------------------------------------------------------
lancastergeneral's Profile: http://www.off.../member.php?u...
View this thread: http://www.off.../showthread.php...

Posted from - http://www.off...

Dave Peterson

12/15/2006 9:48:00 PM

0

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

Debra Dalgleish has some notes:
http://www.contextures.com/xlFuncti... (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.off.../member.php?u...
> View this thread: http://www.off.../showthread.php...
>
> Posted from - http://www.off...

--

Dave Peterson

lancastergeneral

12/15/2006 11:11:00 PM

0


thank you very much. i use vlookup


--
lancastergeneral
------------------------------------------------------------------------
lancastergeneral's Profile: http://www.off.../member.php?u...
View this thread: http://www.off.../showthread.php...

Posted from - http://www.off...