Hi. I am creating a workbook with a dashboard. I need for specific cells in the dashboard to populate based on values in subsequent worksheets. What I need help with is the following:
The workbook consists of the dashboard and four tabs representing quarter one, quarter two, etc. I need the dashboard to reflect the latest entry, for example if a cell in quarter one is not null then replace the value in the dashboard with the value of that cell. If quarter two is not null then replace the same cell with the value in quarter two, etc.
I have tried IF, IF AND, and IF OR statements but I can't get beyond quarter two. When I extend the statement to include the value in quarter three, it gives an error.
Any help you can provide will be greatly appreciated.
The workbook consists of the dashboard and four tabs representing quarter one, quarter two, etc. I need the dashboard to reflect the latest entry, for example if a cell in quarter one is not null then replace the value in the dashboard with the value of that cell. If quarter two is not null then replace the same cell with the value in quarter two, etc.
I have tried IF, IF AND, and IF OR statements but I can't get beyond quarter two. When I extend the statement to include the value in quarter three, it gives an error.
Any help you can provide will be greatly appreciated.