Forum Discussion
JC444
Oct 26, 2021Copper Contributor
Display data from central sheet on multiple sheets
Hi there, When creating a new sheet to display the results, i want all formulas to pluck data from one row down on the central sheet. Sheet attached. Difficult to describe, but basical...
JKPieterse
Oct 26, 2021Silver Contributor
Why not have just one dashboard sheet which uses the INDEX function to get the data from the table using a helper cell near the top of the dashboard in which you can e.g. enter the row number to retrieve?