Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing search feild in middle of seach
I'm kind of new with writing these macros but I've come across a problem I'm
not sure what to do, what my macro is doing so far is I have one spreadsheet and it searches for invoices in spreadsheetA on spreadsheets 1 through 9. Once it finds the invoice number it will copy the entire line and paste it to spreadsheetA, my problem is some of the invoice numbers have letters infront (YM, WM, XM) and the invoices numbers in 1 - 9 have CMM infront. ex in spreadsheetA WM123 will be CMM123 in spreadsheet 1 through 9. Is there a way to have it search through spreadsheet and when it finds WM123 look for CMM123 instead of WM123? please help!! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200703/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Feild Searcher | Excel Discussion (Misc queries) | |||
Changing page orientation in middle of spreadsheet | Excel Discussion (Misc queries) | |||
Extract text in middle using Mid and Find or Search | Excel Discussion (Misc queries) | |||
Changing Feild Color via value | Excel Programming | |||
Want to create a search gui on wkst1 to seach data on other wksts | Excel Programming |