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 basically results sheet number 2 needs to read results from one column down than what results sheet 1 does. What is the best way of doing this please without altering every formula?
Any help much appreciated!
Joe
1 Reply
- 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?
