How to Automatically Display Previous Sheet Values in Excel Meeting Minutes
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.

- 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.
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.
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.
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).
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.
Click the cell containing the new formula and drag the fill handle down or across to apply it to all other action item cells.
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.

Apply an INDEX and VSTACK Formula for Monthly Templates
Use a dynamic array formula to automatically pull data based on the current sheet's position, ideal for setting up a 30-day template.
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. Open your workbook: Launch WPS Spreadsheet and open your daily meeting minutes workbook.
- 2. Start the formula: Select the cell for the action item on today's sheet and type an equals sign (=).
- 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.

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.




