I am very new to writing macros and I have been tasked with the job of taking a worksheet of different phrases and definitions and having them appear in a self created selection window pane when a certain name is clicked. It is confusing to write out but I will show an example below.
Ex. I need to create a macro for our company's internal audit group. A tool they could use to click on the name of the business group and each internal audit standard that would apply to that group would appear (one after another) in a pre-designed selection window pane. SEE BELOW
Worksheet 1-This is the selection menu from which you would click the cell next to the appropriate business group and it would take you to the appropriate definitions
<tbody>
</tbody>
<tbody>
</tbody>
Worksheet 2- When selected, the macro code would be written to jump you to worksheet 2 with the relevant definitions displayed like the example below
<tbody>
</tbody>
<tbody>
</tbody>
Worksheet 3- This would be the hidden worksheet for which the definitions would be contained
<tbody>
</tbody>
Worksheet 4- This would also be a hidden worksheet containing the structure of worksheet 2.
<tbody>
</tbody>
I know that this is very specific, but any help would be greatly appreciated. If anyone knows a general macro code that would structure something similar to this that would be great, or even a link to information helpful to creating a macro code just like. We can also talk off this thread. Comment with your email and I will email you more details.
Thank you!
Ex. I need to create a macro for our company's internal audit group. A tool they could use to click on the name of the business group and each internal audit standard that would apply to that group would appear (one after another) in a pre-designed selection window pane. SEE BELOW
Worksheet 1-This is the selection menu from which you would click the cell next to the appropriate business group and it would take you to the appropriate definitions
<tbody>
</tbody>
| BUSINESS GROUP | SELECTION |
| Production Services | X |
| Logistics | |
| Business Applications | |
| Business Operations | |
| eCommerce |
<tbody>
</tbody>
Worksheet 2- When selected, the macro code would be written to jump you to worksheet 2 with the relevant definitions displayed like the example below
| Production Services |
<tbody>
</tbody>
| 4.2.3 Control of Documents | |
| ISO Definition: -A documented procedure shall be established to define the controls needed to approve documents for adequacy prior to issue. | Manufacturing & Distribution Definition: -approve documents for adequacy prior to use -review and update as necessary and re-approve documents -ensure that relevant versions of applicable documents are available at points of use -ensure that documents remain legible and readily identifiable -prevent the unintended use of obsolete documents |
| Common Internal Audit Questions: Where is this process kept? What steps are followed to ensure there are no nonconforming products? |
<tbody>
</tbody>
Worksheet 3- This would be the hidden worksheet for which the definitions would be contained
| 4.2.3 Control of Documents | |
| -A documented procedure shall be established to define the controls needed to approve documents for adequacy prior to issue. | |
<tbody> </tbody> | |
| Where is this process kept? What steps are followed to ensure there are no nonconforming products? |
<tbody>
</tbody>
Worksheet 4- This would also be a hidden worksheet containing the structure of worksheet 2.
| ISO Definition: | Manufacturing & Distribution Definition: |
| Common Internal Audit Questions: |
<tbody>
</tbody>
I know that this is very specific, but any help would be greatly appreciated. If anyone knows a general macro code that would structure something similar to this that would be great, or even a link to information helpful to creating a macro code just like. We can also talk off this thread. Comment with your email and I will email you more details.
Thank you!
