Inserting data on one sheet from another sheet 
Author Message
 Inserting data on one sheet from another sheet

Here is what I'd like to do (but I can't seem to figure out how using
Validation):

1. I have a table in Excel with row and column headings.
2. The leftmost cell in the row has the name of that row
3. On another sheet in the same workbook I'd like to pull down a
dropdown list that lets me pick from the list of names.
4. When I pick a name, I'd like that row to fill in with the data from
the other worksheet.

Another way of saying this is that I want to pick from a list in one
cell and have other cells fill in with data that is located on another
worksheet.

The Validation command lets me create the list but it won't fill data
into multiple cells.

I'm using Excel XP.

Thanks.



Tue, 22 Feb 2005 04:35:47 GMT  
 Inserting data on one sheet from another sheet
Assume your cell with the validation list is A2. Then one way:

B2: =VLOOKUP(A2, Sheet1!$A$2:$J$100, 2, 0)
C2: =VLOOKUP(A2, Sheet1!$A$2:$J$100, 3, 0)
...


Quote:

> Here is what I'd like to do (but I can't seem to figure out how using
> Validation):

> 1. I have a table in Excel with row and column headings.
> 2. The leftmost cell in the row has the name of that row
> 3. On another sheet in the same workbook I'd like to pull down a
> dropdown list that lets me pick from the list of names.
> 4. When I pick a name, I'd like that row to fill in with the data from
> the other worksheet.

> Another way of saying this is that I want to pick from a list in one
> cell and have other cells fill in with data that is located on another
> worksheet.

> The Validation command lets me create the list but it won't fill data
> into multiple cells.

> I'm using Excel XP.

> Thanks.



Tue, 22 Feb 2005 07:06:16 GMT  
 Inserting data on one sheet from another sheet
You'll probably want to wrap the functions to avoid the #NA:

B2: =IF(A2<>"", VLOOKUP(...), "")


Quote:

> Assume your cell with the validation list is A2. Then one way:

> B2: =VLOOKUP(A2, Sheet1!$A$2:$J$100, 2, 0)
> C2: =VLOOKUP(A2, Sheet1!$A$2:$J$100, 3, 0)
> ...



> > Here is what I'd like to do (but I can't seem to figure out how using
> > Validation):

> > 1. I have a table in Excel with row and column headings.
> > 2. The leftmost cell in the row has the name of that row
> > 3. On another sheet in the same workbook I'd like to pull down a
> > dropdown list that lets me pick from the list of names.
> > 4. When I pick a name, I'd like that row to fill in with the data from
> > the other worksheet.

> > Another way of saying this is that I want to pick from a list in one
> > cell and have other cells fill in with data that is located on another
> > worksheet.

> > The Validation command lets me create the list but it won't fill data
> > into multiple cells.

> > I'm using Excel XP.

> > Thanks.



Tue, 22 Feb 2005 07:10:34 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. How to use data fron one sheet to print forms created in another sheet

2. automaticly copying data from one sheet into another sheet using VBA

3. HELP! Summarize sheet data on one sheet

4. formulas on one sheet affecting data on other sheets

5. using data from one sheet to populate multiple sheets

6. Checking the row data of First Sheet and deleting the related data from the second sheet

7. Linked sheets - Insert rows in all sheets?

8. Linking info in one sheet to another sheet

9. Check if a cell on one sheet is referred to on another sheet

10. Distributing cell values from one Excel sheet to another Excel sheet on another computer - HOW TO


 
Powered by phpBB® Forum Software © phpBB Group