Forum Discussion
auto populating rows from one sheet into other sheets based on criteria
Hi Wyn Hopkins
Thank you- that seems to do the trick! If new rows were added, would they captured (once the table was refreshed)? This is a dynamic list and we will continually be updating and adding to it.
Yes, please explain further... I'm pretty rudimentary in my excel skills. And yes, I'm using 2016.
Hi Ash-7
Yes new rows will be captured as long as they are added to the "Table". The table is that formatted block that should automatically get bigger as you type directly underneath it.
Power Query is found under the Data ribbon. You can click on the button called Queries and Connections
As you see I have done 2 queries AB and BC you would need to duplicate and edit these for the other regions
To do this double click on one query in the right hand window, e.g. BC this opens the Power Query editor
1. Expand the left hand pane and right click on BC and Duplicate
2. Rename this as MB for example and change the formula bar to reference MB rather than BC
3. Click the close and Load option and chose the sheet and cell you want this filtered table to be loaded to
Hope that helps