I have a attached a spreadsheet that contains tab OM and Summary. The OM sheet has a drop down that lets the user select the scope. Then in cells C2:M2 are if statements based on the scope that is selected from the drop down in B3. I will like to know how to get the related items on Summary to paste under the correct headings in C2:M2. For example, if the user select Full O&M then under C2 all the items from the summary tab will be list in regards to C2 and B3 and so forth for the other columns.
Bookmarks