Hi all,
I have a table located on one worksheet that contains some columns & rows that I want to pull into a second table.
So for example, from my table called FY22_Q1 column [Classification] any time the word "Production" comes up, I want to pull the information in the [Name] column onto my new table.
Can anyone help?
I have a table located on one worksheet that contains some columns & rows that I want to pull into a second table.
So for example, from my table called FY22_Q1 column [Classification] any time the word "Production" comes up, I want to pull the information in the [Name] column onto my new table.
Can anyone help?