Turning the items in a table column into the headers of another table and auto update

The formula would be

Formula:

Please Login or Register  to view this content.

Problem is, Excel won't let you have a formula in a Table Header.

You have a tab named "Tech II", but the column header on the "Classes" tab is: "Tech II CUL 108" . The headers on Classes vary in length and number words. There is no indication of how you are determining the tab name from the header string. All of the Class column headers end in a three digit number; you could use those for the tab names.

Please Login or Register  to view this content.

Here's the one I was working on. I was thinking about adding code to parse the column headers and create the sheets but... did not finish.
The only one that works is Tech II since it's the only sheet

Create new sheets with course number as tab name:

Please Login or Register  to view this content.

protonLeah,

I created the tabs by the course number and just changed it from a table to normal and will just add new classes inside the area instead of at the bottom.

The reason I was trying to do it was so it didn't need to be updated in multiple places and so far it seems to be working ok, still in test mode.

The original idea was for a single update point but also that it will feed a master sheet containing 3 dropdowns with the second dependent on the first, and the third drawing information from a separate tab and dependent on the first two. For example DD 1 = Tech II DD2=Lamb DD3=Pork Scallops with Apples. I have the first two figured out and am working out the third.

I hope this makes sense. I did use your idea of the sheets using an array and I managed to get it to look for the number on the "classes" sheet but return the name which is what is preferable for the visual of the final sheet.

Now I have a new problem with another aspect but I think I need to start a new thread for it because it is a different problem? It has to do with deleting duplicates but first moving the column data on the right up to the first occurrence of the duplicate so it can total all occurrences. Currently, it is done manually by sorting by "ingredient" and then moving the data.

Here is where I am at right now, I don't know if this kind of helps you understand what I am trying to do or not and I haven't finished filling in all the data, just trying to get the main items working right now.

Thank you again for all your help,
Cara