VBA & Macro Problems

Track Excel Status Changes and Maintain a Timestamped Audit Trail in WPS Spreadsheets

Bushra ParveenBushra Parveen Nov 13, 2026 869 views

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 start

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.

Solution 1Recommended

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.

1
Open the VBA editor in WPS Spreadsheets

In WPS Spreadsheets, open the target workbook and press Alt + F11 to open the Microsoft Visual Basic for Applications editor.

2
Create a StatusHistory table

Insert a worksheet named StatusHistory and add columns: Subject, Client, OldStatus, NewStatus, and ChangeDate.

3
Add the Worksheet_Change macro

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.

4
Test a status change

Return to the status sheet, change one subject status, and confirm that a new history row is appended with the correct timestamp.

Automation verified: If the macro fires only when the status cells change, the audit trail will keep complete records without manual copy-paste.
WPS Spreadsheets macro solution

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. 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. 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. 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. 4. Build a weekly report: Click Insert > PivotTable and use the StatusHistory table to summarize changes by week, subject, client, or status.
  5. 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.
Automates status change auditing with a timestamped history table and VBA event codeKeeps 6–12 months of history in a report-ready format for weekly summariesOpens and saves Excel macro-enabled workbooks (.xlsm) for Microsoft Office format compatibilityFree, lightweight spreadsheet app with a familiar ribbon and VBA editor
microsoft office alternative - wps office

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.