| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find macro
I want to setup a macro that searches for a part of a cell and then brings back the cell/s relevant to the search. similar to a v lookup but i dont want to have it on the sheet. I want it only as a question box There also may be various accounts on the list with similar Descriptions I would like the display box to display all accounts with the matching string EG account No. 85000 - "WAGES - STAFF" account No. 85500 - "WAGES - CONTRACTS" account No. 85200 - "SUPERANNUATION" Search "Wages" Results 85000 - WAGES - STAFF 85500 - WAGES - CONTRACTS -- XCESIV ------------------------------------------------------------------------ XCESIV's Profile: http://www.excelforum.com/member.php...o&userid=24271 View this thread: http://www.excelforum.com/showthread...hreadid=546937 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get Macro warning, but can't find Macro | Excel Worksheet Functions | |||
| 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 | |||
| Can't find macro | Excel Worksheet Functions | |||
| Can't find a macro | Excel Programming | |||
![XCESIV[_20_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
