Hi Anoop, That code was really helpful. I modified it to help do what I was trying to do. The only problem I have now is that It only seems to apply the type to the first match it finds and disregards the rest of them. Any Idea how I would be able to apply the code to the rest of the rows? Here is my updated copy, The new macro is "FindValue1"
*https://www.box.com/shared/o2dj9iju2f60ohmuvia2*<https://www.box.com/shared/o2dj9iju2f60ohmuvia2> Thanks again for this help. Matt On Tuesday, December 18, 2012 1:33:10 AM UTC-5, Enrique Martin wrote: > Hi Matt, > > Please find attached and run "FindValue" Macro. You can use this macro to > change your codes in order to get the desired result. > In case you don't get it then please let me know so that I can help you > out. > > Regards, > Anoop > > > On Mon, Dec 17, 2012 at 9:20 PM, Matt <mon...@gmail.com <javascript:>>wrote: > >> Hi, i put the link at the bottom of. my question. >> tx >> >> here is the link with the spreadsheet >> >> https://www.box.com/s/33z5kuabqbjn2b971ae6 >> >> matt >> >> -- >> Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-...@googlegroups.com<javascript:> >> . >> To unsubscribe from this group, send email to >> excel-macros...@googlegroups.com <javascript:>. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> > > > -- > Regards, > Anoop > Sr. Developer > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
