So, I got some code from the great people at this forum, and was wondering if it could be tweaked a bit.
The coded copies txt from one field to another, and puts itself at the top of the cell and removes the txt from the previous cell.
The problem is, if cells in the column are blank it has started to put a square symbol in, so when we autofilter it will show squares. I can work around it by filtering for the squares and deleting them manual which is still a time saver. The problem is if the squares get put in between other txt there's no way to delete them. I can live with it, but figured it would be worth asking, as it did not always do this.
Thanks in advance
Please Login or Register to view this content.
Bookmarks