I have a workbook with one tab and I am trying to figure out a macro that will do the following:
1-Take the data in Sheet1 and have the data broken into tabs containing the respective candy
-so a tab for bubble gum, candy bar, licorice, lollipop and stick candy
2-In each tab, have conditional formatting based on value in the Quality column
-red for a value between 0-25
-pink for a value between 26-50
-yellow for a value between 51-75
-green for a value between 76-100
For each tab, I still want each column that exists in Sheet1. I just want them broken out into new tabs.
Bookmarks