data search

[jimmydc716]

I have a very large spreadsheet consisting of 24 col. and 1000's of rows. I can conduct searches using the filter ( ie filter by dept, then by date); however, i want to take the data from what i filtered and extract it for data needed for audits. I know how to create and use countif, index, match formulas and all that but currently i conduct a filtered search and copy the data to a different sheet and then type the codes over and over for each time i do it depending on what i am looking for. is there an easier way?