I’m wondering how to have rows of information from a main sheet automatically populated into various other sheets within the same workbook. The main sheet will continually be updated and added to, so these changes need to be reflected on the other sheets as well. My main “All Sites” spreadsheet contains sites across Canada & the US and I’d like to create individual sheets for each province/state within the same document which automatically populate information from the “All Sites” into the appropriate province/state sheet. For example:
All rows with Alberta in column C of the “All Sites” sheet are automatically populated into the “Alberta” sheet;
All rows with Michigan in column C of the “All Sites” sheet are automatically populated into the “Michigan” sheet; etc.
I'd use Power Query to do this if you have Excel 2016 or are able to download Power Query for Excel 2010/2013
See the attached file, I've populated the 1st 2 sheets, I can explain this further if this seems like a suitable solution. You just right-click and refresh the green tables to update them (or click the Data >Refresh All button)