Hey all,
I have the following problem which I hope someone may be able to support with?! I have a list of locations in A-Z assigned to an Area Example from Cell E1 and F1 downwards...
[TABLE="width: 75"]
<tbody>[TR]
[TD]1[/TD]
[TD]Aberdeen[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Ashford[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Aberdeen II
[/TD]
[/TR]
</tbody>[/TABLE]
What I'm looking to do is in cell B1 have a box where when you enter an Area number it will return all the locations in A-Z from Cell B2 downwards. The issue I have is there are over 300 locations all assigned to Areas 1-22 and I can't seem to get it to just grab the locates to the area number and keep them A-Z
Hope that makes sense
Cheers
S
I have the following problem which I hope someone may be able to support with?! I have a list of locations in A-Z assigned to an Area Example from Cell E1 and F1 downwards...
[TABLE="width: 75"]
<tbody>[TR]
[TD]1[/TD]
[TD]Aberdeen[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Ashford[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Aberdeen II
[/TD]
[/TR]
</tbody>[/TABLE]
What I'm looking to do is in cell B1 have a box where when you enter an Area number it will return all the locations in A-Z from Cell B2 downwards. The issue I have is there are over 300 locations all assigned to Areas 1-22 and I can't seem to get it to just grab the locates to the area number and keep them A-Z
Hope that makes sense
Cheers
S