Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() i need little help i have small table as below. when i enter a date on one cell. progra compare that date with date in coloum 1, if found same date than cop matching colums row in to another sheet. if matching date not foun then give error msg. DATE[/b] * P1* *P2* *P3* *P4* [b]P 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=127799 Posted from - http://www.officehelp.i |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Merge/consolidate text cells based on unique keys ? | New Users to Excel | |||
can i link cells colour wise? | Excel Discussion (Misc queries) | |||
Data row wise, formula column wise | Excel Discussion (Misc queries) | |||
Delete row wise duplicates & colomun wise simultaneously excel | Excel Worksheet Functions | |||
A loop to merge cells based on a value | Excel Programming |