Forum Discussion
excel database
I hope this isn't confusing. I saw a while ago an Excel workbook with a table to keep track of "errors" from reviewing documents. One of the sheets was set up so you could enter data and "submit" and it would add the info to a table on a different sheet. From there you could create a pivot table to analyze who was making what errors the most. I cannot figure out how to create the entry form. Thanks!
1 Reply
AShell23 What you are trying to do is in part what user porcupine_racer was working on in the post I'm having trouble with my VBA code for an entry form to a table. The code there or the attached workbook (macro-enabled) here should give you a start.
Reminder: Macro-enabled workbooks carry a higher risk of malware: e.g., Microsoft Excel Encryption Vulnerability Paves the Way for Malware and Emotet Now Spreading Through Malicious Excel Files, besides the usual data security issues. (Do not open a file that you do not trust! For those that you do, scan them anyway, for viruses/trojans/ransomware; handle them on an isolated computer if possible; open read-only; review all the code before you enable editing. But do not trust password-protected .zip files!)
