Select rows that are 'blinking'
Oke, some explanation.
The first module;
1) Active field is on or more cells. Those could be selected by the user in a range, but it could be also separated selected fields with the CTRL option.
2) The module looks for those active cells in column A and select all rows that have the same data in column A as the active cells in column A (info; Column A is allways sorted).
3) The module copied those records to another file/sheet (after first emptying those file/sheet) and fills in column X the data/time of the copy action, so the user can see that those ones are copied.
The second module;
This should be a follow up action of the first module.
If in the selection of bullit 3, in column L no data was registrated, then a message should popup with those information (= records xxx were empty).
regards, Johan (and thanks for helping me out !!)
|