Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need macro code to pick data according to year selected
Hi,
I'm in need of a macro code for the below scenario A1 B1 C1 D1 E1 A 2000 B 2007 C 2002 D 2010 E 2005 The cell count A1 - E1 may increase or decrease accordingly, need to check the count in run time. I/p is given in cell A2, o/p should return in B2 Macro code should satisfy the foll. conditions: 1. If we give a i/p as say 2003 then the code need to check the value A1 to E1 and should return the value of year less than 2003 i.e. C corresponding to 2001 2. if we give a i/p as 2000 then the code should return value equal to 2000 i.e. A 3. If we give a i/p as 1999 then the code should return value as Z(default) 4. Consider the scenario where year 2000 is not present, then if i/p is given as 2001 then the code should return value as Z(default) Please help me on this case, let me know if you need any more clarifications on the above. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need macro code to pick data according to year selected
On Jul 26, 10:47*am, maniarasan wrote:
Hi, I'm in need of a macro code for the below scenario A1 * * * * * * B1 * * * * * C1 * * * * * * D1 * * * * * E1 A 2000 *B 2007 *C 2002 *D 2010 *E 2005 The cell count A1 - E1 may increase or decrease accordingly, need to check the count in run time. I/p is given in cell A2, o/p should return in B2 Macro code should satisfy the foll. conditions: 1. If we give a i/p as say 2003 then the code need to check the value A1 to E1 and should return the value of year less than 2003 i.e. C corresponding to 2001 2. if we give a i/p as 2000 then the code should return value equal to 2000 i.e. A 3. If we give a i/p as 1999 then the code should return value as Z(default) 4. Consider the scenario where year 2000 is not present, then if i/p is given as 2001 then the code should return value as Z(default) Please help me on this case, let me know if you need any more clarifications on the above. "If desired, send your file to dguillett @gmail.com I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically executing a macro when A pick list item is selected | Excel Programming | |||
macro to browse for workbook, pick up data and looping | Excel Programming | |||
macro to browse for workbook, pick up data and looping | Excel Worksheet Functions | |||
Excel VBA macro - need to edit code to skip a year | Excel Programming | |||
macro to pick data | Excel Programming |