Sample content is within C3:K500 (of Active Workbook, Active Worksheet)
1- Need to look through column K for cells = to "L" (would like to be able to use either alpha or numeric values)
2- If found, then copy whatever is sitting adjacent to it in column C
3- Paste it to 'Sheet3' starting at cell A2 going down
Example:
K5 has a "L" value, so C5's content would get pasted into Sheet3 starting at cell A2 (going down as follows)
K7 has a "L" value, so C5's content would get pasted into Sheet3 .....................A3
K9 has a "L" value, so C5's content would get pasted into Sheet3 .....................A4