Function Problems

How to Automatically Display Previous Sheet Values in Excel Meeting Minutes

Maira MehtabMaira Mehtab Nov 10, 2026 869 views

Question details

The user wants to automatically display action items from the previous day's sheet in the same cells on the current day's sheet without manually copying and pasting.

How to Automatically Display Previous Sheet Values in Excel Meeting Minutes
Product
Microsoft Excel
Device & OS
not provided
Scenario
Managing a daily meeting-minutes workbook with one sheet per day, where pending action items need to automatically carry over to the next day.
Observed behavior
The user needs a formula-based method to reference previous sheet data without triggering circular reference errors when checking for updates.
Before you start

Ensure all your daily sheets are named sequentially or logically (e.g., 1, 2, 3, or Mon, Tue, Wed) to make cross-sheet referencing formulas easier to apply and track.

Solution 1Recommended

Use Direct Cross-Sheet Referencing

Manually link the cell on the current sheet to the corresponding cell on the previous day's sheet to display its value.

This is the most straightforward method to carry over daily action items. It prevents duplication and allows you to overwrite the cell once the task is complete.

1
Select the target cell

Go to the cell on the current sheet where you want the previous day's action item to appear (e.g., cell E7 on Sheet 2).

2
Enter the cross-sheet formula

Type an equals sign (=), then click on the tab for the previous sheet (e.g., Sheet 1), and select the exact same cell (E7). Press Enter. The formula will look like =1!E7.

3
Fill the formula

Click the cell containing the new formula and drag the fill handle down or across to apply it to all other action item cells.

4
Manage completed items

When an action item is completed, simply delete the formula in that cell or overwrite it. This breaks the chain and prevents the completed item from carrying over to the next day.

Use Direct Cross-Sheet Referencing
Avoid Circular References: Ensure you do not accidentally click the current sheet's cell while writing the formula. Referencing the cell you are currently typing in will trigger a circular reference error.
Seamless Spreadsheet Management

Manage Daily Meeting Minutes with WPS Spreadsheet

WPS Spreadsheet offers robust formula capabilities, including intuitive cross-sheet referencing, allowing you to build automated daily meeting templates effortlessly. It seamlessly handles complex workbooks while ensuring complete format compatibility.

  1. 1. Open your workbook: Launch WPS Spreadsheet and open your daily meeting minutes workbook.
  2. 2. Start the formula: Select the cell for the action item on today's sheet and type an equals sign (=).
  3. 3. Select the previous sheet: Click the tab for yesterday's sheet, click the corresponding action item cell, and press Enter to link them automatically.
Easily link data across multiple sheets to automate repetitive meeting minutes.100% compatible with Microsoft Excel (.xlsx) file formats and dynamic formulas.Free, lightweight, and features an intuitive tabbed interface for managing daily tasks.Includes a rich library of customizable meeting minutes templates.
microsoft office alternative - wps office

Frequently Asked Questions

Why am I getting a circular reference error when linking sheets?

A circular reference occurs if your formula accidentally refers to its own cell on the current sheet instead of the target cell on the previous sheet. Double-check your formula bar to ensure it correctly names the previous sheet, such as =1!E7 instead of =2!E7 on sheet 2.

How do I stop a completed action item from showing up on the next day's sheet?

Once an action item is completed or resolved, simply highlight the cell on that specific day's sheet and press Delete, or type the resolution notes over it. Overwriting the formula will stop the data from carrying forward to the sheets of subsequent days.

Can I use a template instead of manually typing formulas for every new sheet?

Yes. You can set up a master workbook containing 31 pre-linked sheets using cross-sheet references. Save this configured workbook as an Excel Template (.xltx). You can then open a fresh, fully-linked copy at the start of every month.