Sheet1 has categories A B C with subsets D E F respectively (ie. Fruit makes list apple, orange, and starberry/Vegetable makes list onion, potatoe,)
On Sheet2 I want to reference subgroups fruit and vegetable which are located on sheet1
What does the "source" area look like for that to happen
I understand interface if its on same tab, but not if interface spans multiple tabs.
Thanks in advance.
On Sheet2 I want to reference subgroups fruit and vegetable which are located on sheet1
What does the "source" area look like for that to happen
I understand interface if its on same tab, but not if interface spans multiple tabs.
Thanks in advance.