Using a hyperlinked cell in a formula
I have a master sheet that pulls data from many other sheets. Each row feeds from another sheet and there is a column that specifically contains the hyperlink to the sheet that row is referencing. Is there a way to write a formula for an entire column to use the hyperlink to pull data from the other sheets? Example below. The "BU" is located in the same place on all of the individual sheets so the formula seems like it should work. I am currently going line by line and "linking cell to a cell in another sheet". I would just like to save some time by writing a column formula so as we add Project Plan rows, it auto feeds. Thank you for any assistance you can provide.
Help Article Resources
Check out the Formula Handbook template!