ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Template for Activity Log with Sorting Capabilities (https://www.excelbanter.com/excel-discussion-misc-queries/54677-template-activity-log-sorting-capabilities.html)

Architect In Pgh

Template for Activity Log with Sorting Capabilities
 
I'm trying to compose a simple form.
First dialog box with user's input of 1. Project ID, 2. Date, 3. Author, 4.
Activity, and 5. Remarks. Data gets exported to Excel list. This is the
data input source.
Second dialog box with user's input of 1. Project ID, and 2. Date Range.
Sortable by Date or Author. Data is gathered from Excel list. This is the
print parameter source.
I've done this with an Excel file, but can't figure it out using a remote
list for access by multiple users which would be valuable.
The list would be archived and not accessible by the user to ensure
security. The only output would be a printed list sortable by Date or
Author. Thx.


All times are GMT +1. The time now is 04:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com