Excel- how to automatically pull a list of data from one tab based on one perameter?

[Freya001]

• Excel
• Macros and VBA
• Training

Hi,

So this is my first time posting!

I am trying to work out a way to automate bringing data in from one tab to the next, for data which falls into a specific category.

E.g Pull all data for accounts cost type of labour.

Please see spreadsheet for an example.

Thank you in advance!

[#2]

@Freya001 

If your version of Excel supports dynamic arrays you may use FILTER() function to show filtered data. Power Query could be an alternative - query source table, filter and return result back. Formulas could be applied as well.

From above FILTER is most suitable from my point of view.