mercredi 7 avril 2021

VBA excel - IF cell contains specific text then move to a new workbook

I have a large dataset with the first column being the variable ClientNames. Some ClientNames have the word "Project" in and I'd like to use VBA to find and select each of the ClientNames which have the word "Project" in and move the entire row for these clients into a new workbook (one workbook with all the clients that have "project" in their ClientName. How can I do this?

Aucun commentaire:

Enregistrer un commentaire