I am trying to create a report in excel format from a big spreadsheet.
because the spreadsheet in use is quite big we want to extract only the
relevant pieces of information from the report for a management report.

there are numerous filters on this report also..

is there a macro code that can be used to tell the macro what it needs to
select, what to filter by (for example there are things that are "active" and
"inactive" on the spreadsheet, management would just like to see the the
active), and once its done this it should format it in a report sort of way.

i recorded a macro and went through each step but it doesnt really work the
way i'd like.

can you please offer some assistance?

thanks very much.