Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
No, I actually do. But not at this particular point. I'm using
offset to give me the data in the cells adjacent to the cell containing the ID. There is another method I am considering, but I haven't gotten it to work: dim rng as range, cell as cell dim wr as long rw=2 set rg=range(cells(1,"H"),cells(rows.count,"H").end(xl up)) for each cell in rg if cell.value=[whatever the id input method is] then cell.entirerow.copy destination:worksheets("Sheet2").Cells(rw,1) rw=rw+1 end if next Or some such; the above is incomplete. Much of it was borrowed from an earlier post to the forum. I'm trying to figure out how to integrate your find statement with the above and present the results in a way that the user can understand without having to know specifics about what is actually happening. This is actually a good project for me. I lack knowledge and experience, but I hope to gain a little of both from this excercise. I appreciate the assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF, OFFSET,MATCH Please Help | Excel Discussion (Misc queries) | |||
index, match, offset worksheet function | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Complicated Index Match Offset function | Excel Worksheet Functions | |||
Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions |