VBA for String search and Calling Sub just for that adjacent cell.

[Grefcon901]

Hello to anyone willing to help! This should be simple but not for a newb. like me.

Over the past week or so I have briefed myself on VBA in a very rough manor. Posted below is the only code I can think of but I do not know how to create a logical range based on the location of where the program finds the string.

What I am attempting:

This sample workbook will have a column of dates and a column of statuses per sheet. Each sheet will also have another column to the right of the "status" column that simply outputs the word "Current" for that date(if this is redundant and you would rather search for the current date in that first column that shows all the dates, feel free to ignore this. I only put it in to make it simple for me).

This program needs to be able to search in the column to the right of the status column for the string "current" and run a sub that copies and pastes that "status" cells value adjacent to it(or just locate the address via the rows date and run the sub for that specific row's "Status" cell if you wanted to ignore the "current" string thing). The Sample will not have the actual formulas in the status cells and only the values I put in for reference but it its the same principle.

Please Login or Register  to view this content.

SAMPLE BOOK.xlsm

Thank You!!

[Bernie Deitrick]

Try this - when looking for dates, it is important to have consistent date formats, which your dates did not, using "mm/dd/yy" for some cells, and "m/dd/yy" for others. So I change the date format to be consistent and allow the date finding to proceed. The code does not need your column T formulas, and it loops through the three sheets.

Please Login or Register  to view this content.