Generic Question About Reporting

[JStellato]

I have a generic question about what direction to go in. I have a spreadsheet with a thousand rows, each row is a record of sorts with about 6 columns of data. I want to "pull" out "records" (I realize they aren't really records as in a database, but let's call a record one row and 6 columns) that match certain criteria and create a new worksheet from the data. Keeping the formatting and record layout.

So the "report" worksheet would look just like one of the rows from the original worksheet, but only contain the "records" that matched the criteria I specify.

What is the best method of doing this? Built in tools? VBA?

Thanks for the help!

 

[shg]

Look at AutoFilter (http://www.contextures.com/xlautofilter01.html) and Advanced Filter (http://www.contextures.com/xladvfilter01.html)

 

[Ruddles]

Another vote for AutoFilter and Advanced Filter.