| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro that does a find and then find next
Start out by looking in the vba help index for FINDNEXT
-- Don Guillett Microsoft MVP Excel SalesAid Software "Galway" wrote in message ... I need a macro. I have two columns. One with various text (column A, worksheet 2). One with a unique text (column B, worksheet 2). I need a macro that will search column A and give me the text in column B. Then Find Next. The same search can find multiple choices from column B. I want all my Column B choices as my result. I am starting with (on worksheet 1, a cell with a small string of text) to be found in Column A on worksheet 2, on worksheet 1 I have a range of cells set aside for the top ## of results from column B on worksheet 2. I hope this is clear. Galway |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace and Find & Insert macro help needed | Excel Programming | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| change error message when no more for "find" in macro to find | Excel Programming | |||
| I need to find a macro to find data cut and paste to another colu. | Excel Programming | |||
| backwards find function to find character in a string of text | Excel Programming | |||
Threaded Mode
