January 27, 2023
I'm a fairly basic user and I've been researching this for a while and realize I'm not sure what verbiage to use to find what I want to accomplish. What I want to do is create a Master List of categories in one sheet. Once this is done, I want to have it copy/paste to a couple other sheets in the same workbook. So far, fairly easy. However, I need to be able to add or subtract categories and have the copied lists auto-update when I change the master list. A scaled down version of the workbook I am using is attached. So far I have managed to confuse myself with offset, copy/paste-link, copy/paste, create table, VBA, and more.
October 5, 2010
No file is attached - you need to click Start Upload after selecting the file.
However, if you look at my example file, you can create a list of categories in Sheet1, and create a table from this list. The table is called Table1.
On any other sheets that you want this list to appear, just type =Table1 into the cell. Any changes to the list on Sheet1 are shown on other sheets too.