Hi all,

I am trying to make a spreadsheet that streamlines all the maintenance codes we use for a piece of equipment. There are five code types, then sub-types broken down according to the modules they pertain to etc.

I have my spreadsheet set up with a drop down menu on sheet 1 that lists the 5 types of codes. Upon selecting one of the drop down items it populates sheet 1 with the specific codes in the range from sheet 3. I have it set up to auto format the hieght width depending on the amount of information in the cell etc.

So far it has been going pretty well. My only issue is that the Work Unit Codes and the How Malfunctioned codes are pretty long so on sheet 3 I grouped them together so the user can expand the list depending on what modules in the equipment are broken. I just do not know how to make sheet 1 incorporate the grouping when it is referencing that data on sheet 3.

Also, sheet 1 pulls the data for each code type from sheet 3 but it doesn't keep the text format (colors/bold etc). Is it possible for me to make it so that the text format and not JUST the text is referenced from sheet 3.

I am attaching the spreadsheet for clarity.

Any help would be appreciated!

Thanks

EDIT: It seems from reading other threads that I will need a macro to do what I want which is fine, I am already using one. So if you know a macro that I can use to basically copy/paste How Mal and Work Unit codes when selected from the drop down, then remove them when one of the others are selected please let me know.