Creating drop down list for multiple cell ranges

[Aaron Saulisberry]

Is there a way to create a drop-down list in cell A1 on sheet1 and pull data
from the followin range of cells (on sheet2) and then place that data in
different cells back on sheet1

A B C D E
F G
1 R-22 B2 776SH 874.85 103.8 -0.1 90847 -87
2 R-22 B2 779SH 876.35 103.7 -0.1 90836 -88
3 R-22 B2 787SH 874.85 103.6 -0.1 90637 -87

I dont know if this is possible but any help would be much appreciate.

[bandbrocks]

The trick to this one is to name the range on Sheet 2. In Data Validation, Excel will not allow you to choose a range outside of the current sheet. In the Data Validation dialog box type the name of the range on Sheet 2 in the Source box with an equal sign in front of it. The validation would be for the cells on Sheet 1.

EXAMPLE:
Defined Range Name - Fubar
Source - =Fubar

Good Luck!

[Dave Peterson]

It's kind of difficult to see what's going on, but if you have a unique key in
the range on Sheet2, you could use Data|Validation to choose that unique key and
then =vlookup() to return the additional columns.

See Debra Dalgleish's site for tips for Data|Validation:
http://www.contextures.com/xlDataVal01.html
and for =vlookup():
http://www.contextures.com/xlFunctions02.html




Aaron Saulisberry wrote:
>
> Is there a way to create a drop-down list in cell A1 on sheet1 and pull data
> from the followin range of cells (on sheet2) and then place that data in
> different cells back on sheet1
>
> A B C D E
> F G
> 1 R-22 B2 776SH 874.85 103.8 -0.1 90847 -87
> 2 R-22 B2 779SH 876.35 103.7 -0.1 90836 -88
> 3 R-22 B2 787SH 874.85 103.6 -0.1 90637 -87
>
> I dont know if this is possible but any help would be much appreciate.

--

Dave Peterson

[Aaron Saulisberry]

Thank you very much Dave... all is working fantastic now!

"Dave Peterson" wrote:

> It's kind of difficult to see what's going on, but if you have a unique key in
> the range on Sheet2, you could use Data|Validation to choose that unique key and
> then =vlookup() to return the additional columns.
>
> See Debra Dalgleish's site for tips for Data|Validation:
> http://www.contextures.com/xlDataVal01.html
> and for =vlookup():
> http://www.contextures.com/xlFunctions02.html
>
>
>
>
> Aaron Saulisberry wrote:
> >
> > Is there a way to create a drop-down list in cell A1 on sheet1 and pull data
> > from the followin range of cells (on sheet2) and then place that data in
> > different cells back on sheet1
> >
> > A B C D E
> > F G
> > 1 R-22 B2 776SH 874.85 103.8 -0.1 90847 -87
> > 2 R-22 B2 779SH 876.35 103.7 -0.1 90836 -88
> > 3 R-22 B2 787SH 874.85 103.6 -0.1 90637 -87
> >
> > I dont know if this is possible but any help would be much appreciate.
>
> --
>
> Dave Peterson
>