Unfilled data worksheet
 

Good day to you.

We have a workbook of 12 worksheets for the 12 months, and one of a set of
columns in each of the data rows needs to have a value manually added. The
rows are being added by an automated process, and aren't added sequentially -
a row may appear in January and October in a single day. All worksheets have
the same design and are separated purely for maintainability and to avoid row
limits.

Given this, for usability I would love to offer a "virtual worksheet" that
has all rows that do not have one of a set of columns filled in. i.e. if the
automated process added a row in January, and two ros in September, upon
opening the workbook the user would see these three rows in the this virtual
worksheet. Given that the workbook is populated via DTS in SQL Server into a
template, I can't add linked columns at that point.

Anyways I was wondering if anyone has had a similar need, and how they
approached it, or if anyone could point me in the best direction to
facilitate this need.

Thank you.