I need to take all cells in column A that have two characters, copy them, and paste them to the second spreadsheet in my workbook. Seems like this should be simple enough to do, but the current segment of my code devoted to doing this isn't working as intended:
It does great in filtering the "[Corporate]" items and copying them to the third worksheet (worksheets are already assigned to ws1, ws2, and ws3), but instead of only taking cells from Column A with two characters, it takes every single cell and copies it to the second worksheet.
The attached workbook has an example of what I would like the second tab to look like. Any help with fixing this code will be greatly appreciated.
Bookmarks