I have a list of companies and I would like to populate other sheets in the same workbook based on the industry the company is in. This list will change regularly and I would like to be able to update the first sheet with the new data and have all the supporting tabs update automatically... Can anyone help with this? I've tried a couple Index/Match formulas and it's just not doing what I want it to.
When you open the spreadsheet I would like a formula that retrieves the ticker of all companies in the 'Basic Materials' industry on the 'Overall List' sheet to populate on the basic materials sheet and so on.
Any suggestions are welcomed!
Thanks,
JJ
Bookmarks