Excel Copy Cells Based on Condition

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
I have an Excel file with a list of contacts on the first sheet. This sheet is labeled "Master List". In column B of the Master List sheet I am putting a letter that designates what type of contact the cell to the left of it is. For instance, if it is someone who can help with Landscaping then I put an "L" in column B, if it is someone who can help with plumbing then I put a "PL" in column B of the Master List sheet. I have created additional sheets in the file so that each type of contact has its own sheet. So along the bottom of the file you would see a Master List sheet, a Landscapers sheet, a Plumbers sheet, etc... Then as I code the contacts in column B of the Master Sheet I would like it to copy the data from Column A into the appropriate sheet based on the code I enter in column B. Is this possible?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
But you can do same with use of filter. By that I mean, if you want to look for Plumbers (hopefully it is not Joe the plumber as he is not licensed one!!), just filter on that ? Am I missing some thing?