copy row when matching colums found

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Gears 14
Moving cells to row with matching data 0
Copying specific rows to another sheet 2
Move to match cells 0
Move to match cells 0
Move to match cells 0
Move to match cells 0
Move to match cells 0

Top