Track Excel Status Changes and Maintain a Timestamped Audit Trail in WPS Spreadsheets
Question details
The user needs to detect subject status changes in a workbook, record the date or week of each change, include the update in weekly reports, and preserve 6 to 12 months of history.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user manages subject or client statuses in a workbook and needs a reliable audit trail for weekly reporting and historical review.
- Observed behavior
- The current workbook relies on separate report sections and checkboxes instead of a structured status history table, so status changes are not automatically timestamped or auditable.
Before you begin, make sure your workbook has a dedicated status history sheet with Subject, Client, OldStatus, NewStatus, and ChangeDate columns. In WPS Spreadsheets, enable macros if prompted so the VBA Worksheet_Change event can run.
Build a normalized history table and append changes with a VBA macro
Use this when you need automatic detection of status changes and a durable, timestamped audit trail.
A single structured history table is easier to audit and report than separate sections or checkboxes. The Worksheet_Change event compares the old and new status and appends one row per change.
In WPS Spreadsheets, open the target workbook and press Alt + F11 to open the Microsoft Visual Basic for Applications editor.
Insert a worksheet named StatusHistory and add columns: Subject, Client, OldStatus, NewStatus, and ChangeDate.
In the VBA editor, open the sheet module for your status sheet, and write a Worksheet_Change event that checks whether Target intersects the status column and then writes the old value, new value, and Now or Date to the next empty row in StatusHistory.
Return to the status sheet, change one subject status, and confirm that a new history row is appended with the correct timestamp.
Create a weekly status change report from the history table
Use this after the history table is populated to summarize changes by week without altering raw data.
Use manual logging when macros are restricted
Use this fallback when macros are blocked by policy and you still need a timestamped history.
Track Status Changes Automatically with WPS Spreadsheets Macros
Use a normalized status history table and a VBA Worksheet_Change event in WPS Spreadsheets to append every status change with a timestamp, then build a weekly report from that history table.
- 1. Download WPS Office and open your workbook: Install WPS Office, open WPS Spreadsheets, and load the Excel workbook that contains your subject status data.
- 2. Normalize the status data: Create a dedicated StatusHistory worksheet with Subject, Client, OldStatus, NewStatus, and ChangeDate columns so every change can be stored as one row.
- 3. Add a Worksheet_Change macro: Press Alt + F11 to open the VBA editor, then insert a Worksheet_Change procedure that appends the old status, new status, and current date to the history table.
- 4. Build a weekly report: Click Insert > PivotTable and use the StatusHistory table to summarize changes by week, subject, client, or status.
- 5. Save as macro-enabled workbook: Click File > Save As and choose Excel Macro-Enabled Workbook (*.xlsm) to preserve the VBA automation and continue using it in WPS Spreadsheets.

Frequently Asked Questions
Can WPS Spreadsheets run Excel VBA macros for status change tracking?
Yes. WPS Spreadsheets supports VBA and can open macro-enabled .xlsm workbooks. Press Alt + F11 to open the VBA editor and add or edit a Worksheet_Change event.
How do I automatically record the date or week of each status change?
In your Worksheet_Change macro, write Date or Now to the ChangeDate column when a status cell changes. You can then format that column as a date or use the WEEKNUM function for weekly grouping.
How can I create a weekly report from the status history table?
Select the history table, click Insert > PivotTable, add ChangeDate to Rows, group it by week, and add Subject or Status as needed. Refresh after each macro update.
What if my current workbook uses checkboxes instead of a status table?
Checkboxes are harder to audit. Keep them for data entry if needed, but have the macro write each status change into a normalized StatusHistory table; use that table as the single source for reports.
How much status history can WPS Spreadsheets handle?
A normal spreadsheet can easily handle 6–12 months of status changes, often thousands of rows. Keep the history in one table and use PivotTables or filters to query specific periods.




