Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
matching and finding data
hi,
how do i match columnA in spreadsheetA with columnB in spreadsheetB to find the value in columnD of spreadsheetB ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
matching and finding data
this code put the results in column B of spreadsheetA
set shtA = sheets("spreadsheetA") set shtB = sheets("spreadsheetB") RowCount = 1 with ShtA Do while .range("A" & Rowcount) < "" Data = .range("A" & Rowcount) Set c = ShtB.Columns("B").find(What:=Data, _ lookin:=xlvalues, lookat:=xlwhole) if not c is nothing then .Range("B" & RowCount) = c.offset(0,2) end if RowCount = RowCount + 1 loop end with "Lynn" wrote: hi, how do i match columnA in spreadsheetA with columnB in spreadsheetB to find the value in columnD of spreadsheetB ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding cells with matching data | Excel Programming | |||
vlookup not finding matching data | Excel Worksheet Functions | |||
Finding Matching Data on Another Sheet | Excel Programming | |||
Finding matching cell data | Excel Worksheet Functions | |||
Importing and Finding Matching data | Excel Programming |