Forum Discussion
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...
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?