I'm looking to create a list of company names that dynamically update on separate sheets as I add new companies. I want the list on one sheet and I want that list to appear on multiple sheets and create a new row that's part of a sorted list each time I add a new company. For Example:
current list on sheet 1, 2, and 3 (sheet 1 is this data only; sheet 2 and 3 have different data sets)
ABC Company
XYZ Company
I update sheet 1 to the following:
ABC Company
XYZ Company
NEW Company
Now, when I make that addition, I want a new row created on sheets 2 and 3 automatically.
Anyone know how to do this?
Bookmarks