Copy, Filter & Paste Set Columns Based on Values

[AJLS]

Hi,

I currently have a filter and match reference from a table on another sheet. What I am looking to do is have this information copied and pasted onto the next sheet:

=IFERROR(FILTER(Aberdeen!A3:C25,ISNUMBER(MATCH(Aberdeen!L3:L25,{"Required";"Ongoing"},))*ISNUMBER(MATCH(Aberdeen!F3:F25,{"Received"},))), "") - plus another three similar formula's.

The rows I want the data from are A, B, C, G, H, M, and O, filtered by "Required" "Ongoing" in column L and "Received" in column F. If possible I am hoping the sheet will update automatically when new entries meet the criteria and when current entries no longer meet the criteria.

Thanks

 

[Fluff]

How about

=FILTER(CHOOSECOLS(Aberdeen!A3:O25,1,2,3,7,7,13,15),ISNUMBER(MATCH(Aberdeen!L3:L25,{"Required";"Ongoing"},))*ISNUMBER(MATCH(Aberdeen!F3:F25,{"Received"},)),"")

 

[AJLS]

How about

=FILTER(CHOOSECOLS(Aberdeen!A3:O25,1,2,3,7,7,13,15),ISNUMBER(MATCH(Aberdeen!L3:L25,{"Required";"Ongoing"},))*ISNUMBER(MATCH(Aberdeen!F3:F25,{"Received"},)),"")

Hi Fluff,

Thanks for this option, I am getting a spill error on this, I am hoping there is a macro based solution. I have tried putting something together based on online tutorials but I am just winging it and it is not working.

 

[Fluff]

If you use a macro to copy paste the values, then it will never update automatically when the data changes, whereas that formula will.
The #Spill error means that you have cells with data in the way of the formula. Clear the cells & the formula can spill

 

[AJLS]

If you use a macro to copy paste the values, then it will never update automatically when the data changes, whereas that formula will.
The #Spill error means that you have cells with data in the way of the formula. Clear the cells & the formula can spill

I'll keep the values as reference only. Thanks for the help.

 

[Fluff]

You're welcome & thanks for the feedback.