Hello, In a cell, instead of displaying:
=SUM(U30+AF30)
would it be possible to quickly display what U30 and AF30 are within the cell? like so:
=(SUM(Database!U3)-SUM(Database!I3,Database!K3,Database!Q3))-(SUM(Database!I3,Database!K3,Database!Q3))
What I'm trying to do is eliminate the first level of cell references for all the cells in a table and just have them display the databases they are referring too like in the second line. Manually copying and pasting the references over would take a while.
Thank you.
V
Bookmarks