Pasting rows in new workbook from specific column items

[mwalter2001]

I have a workbook with a master sheet and corresponding individual sheets based on class #'s.

How do I paste multiple rows (i.e. rows 3,6,14 and 21)fro the master worksheet because they match the class number (Column B) into a new worksheet (call it class 001)? All the information in sheet 001 should be unique to class 001, same with class 002, etc.

 

[GR00007]

Quick-n-dirty:
- Filter master to selected values
- Copy selected rows (and header if you want)
- Go to empty worksheet and paste at A1
Note, there is a paste special option where you can select values and number formats instead of all (including formulas).

 

[mwalter2001]

Thank you but I was looking more for an automatic function - versus the cut and paste routine that I know how to use. There are 10 different classes and the master sheet. Names are randomly entered (basically as I receive them) and I would like to auto update the class sheets. That way I only make one entry and can access data for each class separately.

 

[GR00007]

I've searched this site using "VBA copy paste based single criteria" and found many responses.
Here's one that looks extremely similar to what you are looking for: https://www.mrexcel.com/forum/excel...eria.html?highlight=copy+sheet+based+criteria