| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i create a macro to find a specific data?
Let say i have the following dates starting from call "A7"
(Note : All cells are formulas, not actual key-in dates) 31-Mar-05 01-Apr-05 02-Apr-05 .. .. 29-Mar-06 30-Mar-06 31-Mar-06 And in Cell "A4" (also formula) is the date 29-Mar-06. What i need is a macro for find the cell for this date and then move 3 columns to the right. Thanks in advance. p.s. I not very good in macro, get ready for more stupid questions. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i create a macro to find a specific data?
How about a VLOOKUP formula? You won't need a macro at all.
look for the value in A4 in the first column of the range A7:D50 and return the value in the same row n column 4 cell B4: =vlookup($A$4,$A$7:$D$50,4,0) "James" wrote in message ... Let say i have the following dates starting from call "A7" (Note : All cells are formulas, not actual key-in dates) 31-Mar-05 01-Apr-05 02-Apr-05 . . 29-Mar-06 30-Mar-06 31-Mar-06 And in Cell "A4" (also formula) is the date 29-Mar-06. What i need is a macro for find the cell for this date and then move 3 columns to the right. Thanks in advance. p.s. I not very good in macro, get ready for more stupid questions. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i create a macro to find a specific data?
Actually, I need this is because i want to paste a value into this cell. And
this worksheet will then be used as a database for my vlookup formulas. "Rob" wrote: How about a VLOOKUP formula? You won't need a macro at all. look for the value in A4 in the first column of the range A7:D50 and return the value in the same row n column 4 cell B4: =vlookup($A$4,$A$7:$D$50,4,0) "James" wrote in message ... Let say i have the following dates starting from call "A7" (Note : All cells are formulas, not actual key-in dates) 31-Mar-05 01-Apr-05 02-Apr-05 . . 29-Mar-06 30-Mar-06 31-Mar-06 And in Cell "A4" (also formula) is the date 29-Mar-06. What i need is a macro for find the cell for this date and then move 3 columns to the right. Thanks in advance. p.s. I not very good in macro, get ready for more stupid questions. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a new worksheet with a macro and giving it a specific name | Excel Discussion (Misc queries) | |||
| Find highest value in a specific data set. | Excel Discussion (Misc queries) | |||
| HOw do i find and sort out data repeats for specific data set | Excel Discussion (Misc queries) | |||
| Can I create a formula to find a specific value within a group of. | Excel Worksheet Functions | |||
| How to create Specific date in macro code | Excel Programming | |||
Linear Mode
