Using MS Office Professional 2010.
Question: How to use VBA to autofilter for a specified criteria, then insert text into a cell located further down the row
By recording a macro I was able to establish a filter:
Attached is a stripped down copy of the file, normally there is a graphic interface so the macros are assigned to certain buttons (which is why we're not using the already built-in filter capability). When executed, the macro above works as desired, finding all instances in a hundred item list. There is potential for data on the "Location" tab to change slightly each month, so I test the data periodically by executing each macro, then putting a "found" into column Z. When all macros have been excecuted I look for any row without a "found", then I know to create a new filter. As you can imagine the process is laborious and consumes a significant period of time.
The attached file has the VBA modules already and the tab has been mocked up to show the desired result for column Z. My knowledge of Excel forumulas is scant and VBA less so, but I've attempted variations with ActiveCell and .Offset among others.
My hope is there's some code I can copy & paste by hand into the each macro that will add the "found" text.
Thank you in advance for any insight and assistance you can share.