Dynamic Ranges?
I am using a combo dropdown list. The list is linked to a name range.
I need the name range to change based on the value of another cell. Example If i put X in A1 = x Then A2 = "NameRange1" but... If i put Y in A1 = y Then A2 = "NameRange2" Is this posible? Thank you for your help, Steve |
Dynamic Ranges?
Create a Range MyRange and make it equal the following formula
=if(Sheet1!$A$1="x",NameRange1,NameRange2) Alok Joshi "Smonczka" wrote: I am using a combo dropdown list. The list is linked to a name range. I need the name range to change based on the value of another cell. Example If i put X in A1 = x Then A2 = "NameRange1" but... If i put Y in A1 = y Then A2 = "NameRange2" Is this posible? Thank you for your help, Steve |
Dynamic Ranges?
Alok, thanks for your help. That worked perfectly.
|
All times are GMT +1. The time now is 06:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com