Formula to copy filtered data to another tab

[robertguy]

Hi,

I have data entered on to a tab called ‘Data’ and what I want to do is to populate the ‘Output’ tab with data filtered from the ‘Data’ tab i.e. filter on column ‘B’ (Type) for ‘Project’, Major Project’ and ‘Minor Project’ only.

Can anyone please advise me of the formulas required to copy the filtered data from the ‘Data’ tab to the ‘Output’ tab i.e. the filtered data in columns 'A' to 'C'

I have attached example file which shows the desired result on the Output’ tab.

I appreciate this could be done via macros/vba or advance filtered but in this instance a formula solution is required

Many thanks in advance for any assistance received

Regards


Rob