Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for strings listed in column - Excel 2007
Hello:
Here's what I'm trying to do: 1.) Create a workbook (WB1) with a list of words in A1 - A50. 2.) Open up another workbook (WB2) that already has existing data. This workbook gets sent to me everyday with new data. 3.) Run a macro to search and for all words in WB2 that are on the list in WB1. For each word listed in WB2, I want to change the text of the cell to red and bold with a thick red border. Right now I have something that does something like this, but I have the macro in PERSONAL.XLSB and the list of search strings are hardcoded in the macro. To make it more user friendly, I'd like to have the search string in a column so that updates to the strings can be made without modifying the macro itself. Please direct me to any sample code to do this. I've been searching but I don't know the correct terms to search for, so I'm not getting any relevant results. Thank you. -- Regards, M MCTS, MCSA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 sets of =if strings in excel 2007 | Excel Discussion (Misc queries) | |||
How to sort by ZIP codes listed in one column in Excel spread sh? | Excel Discussion (Misc queries) | |||
Search & Extract various strings from many files to one excel file | Excel Programming | |||
Fast way to search many cells by column for text strings | Excel Discussion (Misc queries) | |||
Copy Excel data content listed in 3 columns into a single column | Excel Programming |