Macro code to build to pull from a range of information

gmartinez

New Member
Joined
Nov 7, 2013
Messages
2
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>
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.

  • 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

<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!
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,005
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,177
Messages
5,600,160
Members
414,367
Latest member
dw970906

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top