Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find a particular cell using macro?
Ok, let me explain. I have a worksheet it consist of the following Column A Column B Column C ..... 2-Aug-06 Units 1-Aug-06 2-Aug-06 ..... list goes on Unit-A Unit-B Cost 1-Aug-06 2-Aug-06 ..... list goes on Unit-A Unit-B Sales 1-Aug-06 2-Aug-06 ..... list goes on Unit-A Unit-B Let's say today is the 2-Aug-06 in cell "A1" (this is a referring t another worksheet). Now i want to activate the cell under "Cost" fo "Unit-B" for that particular date, which is cell "C9". Can anybody help me write a macro to find and activate this cell? Thanks in advance. : -- Infinit ----------------------------------------------------------------------- Infinity's Profile: http://www.excelforum.com/member.php...fo&userid=3272 View this thread: http://www.excelforum.com/showthread.php?threadid=57363 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find a particular cell using macro?
Infinity,
I don't think you need code to do this but more formatting of the sheet with the Vlookup Code... Have you considered using all 256 dates (top row) and assigning a HLOOKUP code? Infinity wrote: Ok, let me explain. I have a worksheet it consist of the following Column A Column B Column C ..... 2-Aug-06 Units 1-Aug-06 2-Aug-06 ..... list goes on Unit-A Unit-B Cost 1-Aug-06 2-Aug-06 ..... list goes on Unit-A Unit-B Sales 1-Aug-06 2-Aug-06 ..... list goes on Unit-A Unit-B Let's say today is the 2-Aug-06 in cell "A1" (this is a referring to another worksheet). Now i want to activate the cell under "Cost" for "Unit-B" for that particular date, which is cell "C9". Can anybody help me write a macro to find and activate this cell? Thanks in advance. :) -- Infinity ------------------------------------------------------------------------ Infinity's Profile: http://www.excelforum.com/member.php...o&userid=32725 View this thread: http://www.excelforum.com/showthread...hreadid=573630 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find a particular cell using macro?
The file was done in a particular manner so that the values there ar being lookup. I cant change the format now, the file is too big.:( Btw, i need to activate the cell is because i want to copy some value there. hope that u can help me out here. Thanks again..: -- Infinit ----------------------------------------------------------------------- Infinity's Profile: http://www.excelforum.com/member.php...fo&userid=3272 View this thread: http://www.excelforum.com/showthread.php?threadid=57363 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find a particular cell using macro?
Actually i manage to find the row for "Cost" but then i cant seem t figure out how do i go to the particular date and activate the cel below... Here's what i did.. For Each c In Range("A:A") If c.Value = "Cost" Then c.Cells(1, 1).Select ActiveCell.EntireRow.Select End If Next c Please help and thanks.: -- Infinit ----------------------------------------------------------------------- Infinity's Profile: http://www.excelforum.com/member.php...fo&userid=3272 View this thread: http://www.excelforum.com/showthread.php?threadid=57363 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find a particular cell using macro?
Sorry for being buggy... but anybody? Please... Pretty please.. -- Infinity ------------------------------------------------------------------------ Infinity's Profile: http://www.excelforum.com/member.php...o&userid=32725 View this thread: http://www.excelforum.com/showthread...hreadid=573630 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Contents of Cell (Macro) - Help me! | Excel Programming | |||
Find red cell in macro | Excel Programming | |||
How to find speicial cell using macro | Excel Programming | |||
Macro to find blank cell | Excel Programming | |||
macro to find out the last cell in a range | Excel Programming |