Hi all. I am a first time poster and I am sure it will show. I am working on a simple contact list for communication distribution. The first sheet lists all known company sales contacts (customers and prospects).
We have 2 basic customer types (lets call them type 1, and type 2). On the same first sheet I have two columns for each of these distinctions and the data entry is "yes" or "no". My objective is to copy this contact information to a different sheet depending on the data in these two columns. If "type 1" equals yes, then copy entire row to the sheet titled Type 1 customers. If "type 2" equals yes, then copy entire row to the sheet titled Type 2 customers. If the answer is "no" to both types of customers, then copy the entire row to the sheet named Prospects.
I realize that these would be fairly simple IF statements but when copying the data to the other sheets I would like it to find and fill the next available row so that the lists are not broken up by a lot of empty rows. Any suggestions?
Thanks for helping a newbie!
Bookmarks