Need a macro to delete all cells that do not fall under one category

**brandonlaw** · 07-27-2012, 02:52 PM

I have a workbook with 10 sheets. Every sheet has three columns (with the title in cells A1, B1, and C1 respectively): Supervisor, Center, ID Number.

There are 5 supervisors: Sean, Ye, Marshall, Donald, and Kendrick.

I need to create a workbook where only one Supervisor's info is present on all 10 sheets and everything else is deleted. Each sheet is of varying length, some sheets may have 200 entries, some may have 2,000.

This will require 5 different macros (1 for each supervisor), but if you can write me a macro just for Sean I will update it accordingly.

Thanks!
Example of what I need (assume the Supervisor cell is in A1):
EXAMPLE.xlsx

**arlu1201** · 07-27-2012, 02:56 PM

Do you have a sample file that you can attach?

**brandonlaw** · 07-27-2012, 02:59 PM

Originally Posted by arlu1201

Do you have a sample file that you can attach?

Yeah, just uploaded it, thanks.

---------- Post added at 02:59 PM ---------- Previous post was at 02:58 PM ----------

If I was to do this without a macro, I'd sort every sheet by supervisor and delete all the rows with supervisors I don't want.

Hopefully that helps explain what I am looking for.

**JBeaucaire** · 07-27-2012, 03:01 PM

You can do this with an AUTOFILTER. You can use a popup to ask you for the name to filter by.

Wouldn't it be more practical to leave the 10 sheets as is and collect all of "sean's" info onto one sheet?