| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching two different colums, VLOOKUP? | Excel Discussion (Misc queries) | |||
| Copy Cells Found | Excel Discussion (Misc queries) | |||
| How do I copy only the unhidden rows/colums? | Excel Discussion (Misc queries) | |||
| How to copy&paste a variable range rows and colums | Excel Discussion (Misc queries) | |||
| Get matching values and formulas from ajoining colums of dropdown | Excel Discussion (Misc queries) | |||
![lancastergeneral[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
