I have two Names defined - one on Worksheet "Sheet1" with Name = Items
The second is on Worksheet "Sheet2" with Name = Second_Items
On worksheet 3, I would like to give the user a dropdown with a concatenated list of Items & Second_Items to select from. Is there any way to do this?
The formula for both Names are as the following:
='Sheet1'!$L$8:INDEX('Sheet1'!$L$8:$L$9999,MATCH(REPT("z",255),'Sheet1'!$L$8:$L$9999))
The second is on Worksheet "Sheet2" with Name = Second_Items
On worksheet 3, I would like to give the user a dropdown with a concatenated list of Items & Second_Items to select from. Is there any way to do this?
The formula for both Names are as the following:
='Sheet1'!$L$8:INDEX('Sheet1'!$L$8:$L$9999,MATCH(REPT("z",255),'Sheet1'!$L$8:$L$9999))