Thread: Changing search feild in middle of seach
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tina via OfficeKB.com Tina via OfficeKB.com is offline
external usenet poster
  
Posts: 7
Default 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

Reply With QuoteReply With Quote