Forum Discussion
Auto populating multiple sheets from a master sheet based on a category drop down
hello. We are a start up and are currently using a master list to track all external meetings until we determine the best CRM system. This master contains 14 columns of data, hundreds of rows of c...
A possible solution could be Power Query. In the attached file you can enter meetings in the blue dynamic table in the master sheet. Then you can click in any cell of a green table and right-click with the mouse and select refresh in order to update this green result table.
Master Sheet:
Sheet Car with the result table for category "Car":