Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Cell with Value and get Value of Cell Below it
I need to find the word "Tackles" in Column E and then have the value
of the cell below it inserted into B15 on another sheet. This seems like it would be simple...but for some reason cant do it, lol. Any Help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Cell with Value and get Value of Cell Below it
this may give you an idea:
Option Explicit Sub find_it() Dim ws As Worksheet Dim ws1 As Worksheet Dim rng As Range Dim rngfound As Range Set ws = Worksheets("Sheet1") Set ws1 = Worksheets("sheet2") Set rng = ws.Columns(5) With rng Set rngfound = .Find("tackles", LookIn:=xlValues) If Not rngfound Is Nothing Then ws1.Range("B15").Value = rngfound.Offset(1) End If End With End Sub -- Gary Keramidas "CribbsStyle" wrote in message ... I need to find the word "Tackles" in Column E and then have the value of the cell below it inserted into B15 on another sheet. This seems like it would be simple...but for some reason cant do it, lol. Any Help? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Cell with Value and get Value of Cell Below it
Name the cells with data in column E. I used the name "LookupRange" Place this formula in cell B15... =INDEX(LookupRange,MATCH("Tackles",LookupRange,0)+ 1,1) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "CribbsStyle" wrote in message I need to find the word "Tackles" in Column E and then have the value of the cell below it inserted into B15 on another sheet. This seems like it would be simple...but for some reason cant do it, lol. Any Help? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Cell with Value and get Value of Cell Below it
On Jan 12, 12:22 am, "Jim Cone" wrote:
Name the cells with data in column E. I used the name "LookupRange" Place this formula in cell B15... =INDEX(LookupRange,MATCH("Tackles",LookupRange,0)+ 1,1) -- Jim Cone San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "CribbsStyle" wrote in message I need to find the word "Tackles" in Column E and then have the value of the cell below it inserted into B15 on another sheet. This seems like it would be simple...but for some reason cant do it, lol. Any Help? Perfect! Thank You Very Much! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Cell with Value and get Value of Cell Below it
One question, lets Say I have "Tackles" in D7, D14 and D21. Is their
anyway to refer to the second instance? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Cell with Value and get Value of Cell Below it
See the response from Gary Keramidas. Add a "FindNext" and exit on the second successful find. The "Find" example in help will help. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "CribbsStyle" wrote in message One question, lets Say I have "Tackles" in D7, D14 and D21. Is their anyway to refer to the second instance? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
find first empty cell in column and start transpose next row in that cell | Excel Programming | |||
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON | Excel Programming | |||
UDF code to find specific text in cell comments, then average cell values | Excel Programming | |||
find text in a cell and make cell 2 cells below that active | Excel Programming |