PDA

View Full Version : Filter data and copy to another worksheet



electriceaze
10-04-2011, 04:11 PM
I am looking for code...pls help.:think:

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. :thumb