I'm currently working on a excel worksheet, and have been having issues trying to figure out how to export the output cells into a table format. I want to be able to have a table generated with all the possible variations that I've inputted. Is this possible or do I have to generate the table by hand? For example, I have a part with multiple options. I've created a chart that has each variable set up for a drop down list and the final cell with the part number (the output cell) changes based on what I've selected for the variables. Is there anyway to have that output cell generate a table that lists all the options?
Bookmarks