Is there a way with VB that I can have rows from one workbook copy into another workbook as long as there is text in a certain column?
For instance, I want a list of contacts to be copied over into a separate workbook only if the contacts have an email address listed. If they do not have an email address, I dont want them copied over.
Bookmarks