Forum Discussion
If function
Is there a way to create a formula where data gets pulled into another sheet, within the same workbook, if and only if certain criteria are met? For instance, I have a master tab where information ...
You can use a Power Query to pull the filtered data across.
- Click Data Tab > From Table/Range
- Power Query will open up displaying the table.
- Filter the columns as needed
- Click Close & Load in top left
- A new sheet will be displayed with a table that contains only the filtered data
Let me know if it works
- Click Data Tab > From Table/Range
- Power Query will open up displaying the table.
- Filter the columns as needed
- Click Close & Load in top left
- A new sheet will be displayed with a table that contains only the filtered data
Let me know if it works