I have a excel workbook (wb1) where the columns is showing the months and the rows is showing different actions that take place. If an action takes place in a specified month the cell corresponding to both the action and the month is marked yellow.
In another workbook (wb2) I want to be able to retrieve data from wb1. I want to search wb1 to find the first action that takes place in the current month and import the action text into a cell in wb2. Is this possible