Macro code to build to pull from a range of information

[gmartinez]

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
[TABLE="width: 453, align: left"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]BUSINESS GROUP
[/TD]
[TD]SELECTION
[/TD]
[/TR]
[TR]
[TD]Production Services
[/TD]
[TD="align: center"]X
[/TD]
[/TR]
[TR]
[TD]Logistics
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Business Applications
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Business Operations
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]eCommerce
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]





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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Production Services
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]4.2.3 Control of Documents
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ISO Definition:
-A documented procedure shall be established to define the controls needed to approve documents for adequacy prior to issue.
[/TD]
[TD]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
[/TD]
[/TR]
[TR]
[TD]Common Internal Audit Questions:
Where is this process kept?
What steps are followed to ensure there are no nonconforming products?
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Worksheet 3- This would be the hidden worksheet for which the definitions would be contained

[TABLE="width: 500"]
<tbody>[TR]
[TD]4.2.3 Control of Documents
[/TD]
[/TR]
[TR]
[TD]-A documented procedure shall be established to define the controls needed to approve documents for adequacy prior to issue.
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]

• 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

[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Where is this process kept?
What steps are followed to ensure there are no nonconforming products?
[/TD]
[/TR]
</tbody>[/TABLE]

Worksheet 4- This would also be a hidden worksheet containing the structure of worksheet 2.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ISO Definition:



[/TD]
[TD]Manufacturing & Distribution Definition:



[/TD]
[/TR]
[TR]
[TD]Common Internal Audit Questions:




[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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!

 

[oldbrewer]

Before I retired I worked in QA and business improvement. I am familiar with ISO 9001 and was a trained auditor. Happy to try and assist with this - it is too big for here I believe so PM me your Email and I will contact you.