Hi,
I need to resolve a pressing issue that I have at work. Here is my dilemma.
Background Info:
Currently, I have 15 users who submit data to me on Excel 2003 spreadsheets that I in turn manipulate to report elsewhere (to upper mgt, the government, etc…). In the short term, I need to standardize the process because different users submit their workbooks in a variety of ways. Some would send me plain data while others would send me pivot tables, password protected worksheets with hidden columns, etc... I also need to create a “data attestation form”, to force users to acknowledge that the data being submitted is complete and accurate to their best knowledge. The attestation form should be a printable form for auditing purposes and it should also control the worksheet that has the actual data in the following manner: if the attestation form is not completed, a user cannot save the new workbook and once saved, the workbook cannot be modified. The attestation form should also be able to accommodate multiple signatures (see attachment). Is this even remotely possible?
I created a workbook template for each user because each report is different. I also replicated in Excel an existing paper data attestation form that we use for audits. My problem is that I have no VBA knowledge (although I have been trying to learn as much as I can lately) and I cannot find a solution to make the save workbook feature conditional to completing the data attestation form entirely. PLEASE...PLEASE…HELP. May God bless you guys!
Recap:
I needed to control and standardize how data is submitted by each user so I created templates that should be populated.
I need these users to sign a digital/printable form attesting that they did their due diligence to obtain accurate data.
I need to ensure that no data is submitted to me without a signed attestation (this is a must).
ANY SOLUTION that will ensure these conditions will be welcomed.
I need to resolve a pressing issue that I have at work. Here is my dilemma.
Background Info:
Currently, I have 15 users who submit data to me on Excel 2003 spreadsheets that I in turn manipulate to report elsewhere (to upper mgt, the government, etc…). In the short term, I need to standardize the process because different users submit their workbooks in a variety of ways. Some would send me plain data while others would send me pivot tables, password protected worksheets with hidden columns, etc... I also need to create a “data attestation form”, to force users to acknowledge that the data being submitted is complete and accurate to their best knowledge. The attestation form should be a printable form for auditing purposes and it should also control the worksheet that has the actual data in the following manner: if the attestation form is not completed, a user cannot save the new workbook and once saved, the workbook cannot be modified. The attestation form should also be able to accommodate multiple signatures (see attachment). Is this even remotely possible?
I created a workbook template for each user because each report is different. I also replicated in Excel an existing paper data attestation form that we use for audits. My problem is that I have no VBA knowledge (although I have been trying to learn as much as I can lately) and I cannot find a solution to make the save workbook feature conditional to completing the data attestation form entirely. PLEASE...PLEASE…HELP. May God bless you guys!
Recap:
I needed to control and standardize how data is submitted by each user so I created templates that should be populated.
I need these users to sign a digital/printable form attesting that they did their due diligence to obtain accurate data.
I need to ensure that no data is submitted to me without a signed attestation (this is a must).
ANY SOLUTION that will ensure these conditions will be welcomed.
