Hello all,
(Very first post and as mentioned extremely new to VBA - which programmers tell me will melt my brain )
I have some code already that works to open a workbook and search for a keyword and copy the cells next to that word. Now I have a need to search designated workbooks for a keyword and copy the entire column of data (or last cell in that column that contains a value).
Example:
<tbody>
</tbody>
I would have to search the workbook (which is really only 1 sheet in csv format) for the word Speed and then return the last cell values (1379 and 1344 in this case). The book it is searching can see anywhere from 3-8 instances of the keyword.
Thanks in advance!
Dave
(Very first post and as mentioned extremely new to VBA - which programmers tell me will melt my brain )
I have some code already that works to open a workbook and search for a keyword and copy the cells next to that word. Now I have a need to search designated workbooks for a keyword and copy the entire column of data (or last cell in that column that contains a value).
Example:
A | B | C | D | E | F |
Name | Speed 1 | Condition Count | Speed 2 | Condition Count | Total Counts |
Bob | 456 | 4 | 654 | 6 | 10 |
Jane | 789 | 6 | 345 | 7 | 13 |
Phil | 234 | 4 | 345 | 3 | 7 |
Totals | 1379 | 1344 | 30 |
<tbody>
</tbody>
I would have to search the workbook (which is really only 1 sheet in csv format) for the word Speed and then return the last cell values (1379 and 1344 in this case). The book it is searching can see anywhere from 3-8 instances of the keyword.
Thanks in advance!
Dave