Filter data and copy to another worksheet

I am looking for code...pls help.

I have a workbook with a master worksheet named 'Claims'. Each row is a claim with data in columns A thru P. Column G is titled 'Issue Code' and I would like to filter by Issue Code and copy those rows of data to a separate worksheet. There are 7 different issues codes so my result should be 7 additional worksheets within my workbook.

Any help is appreciated.

Try this link:

https://sites.google.com/a/madrocket...eet1-to-sheets

Originally Posted by davegugg

Did you try using the macro recorder first?

_____________

No, would I simply filter the data then copy and paste? and would that continually update the filtered data worksheets when the master spreadsheet is updated?

If you go to the link i provided above, it gives you a very easy way of getting the output you desire through code.