User Profile
NicolasIlg
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Referencing Spreadsheet Named in a Cell
Hi! I have Spreadsheet 1 where multiple cells are functions of cells in a different spreadsheet. For Example=SUM('[Other Spreadsheet.xlsx]Tab'!$I$131:$K$131) I would like to have a cell where I name the Other Spreadsheet and if I change this name to Other Spreadsheet Number 2, then all the formulas on Spreadsheet 1 will start referring to a different spreadsheet called Other Spreasheet Number 2. All those spreadsheets would be on sharepoint and accessible to other people in my company. Any ideas on how to do this? Thanks a lot in advance!548Views0likes1Comment
Recent Blog Articles
No content to show