Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputing information from one worksheet to another
In the last month, I feel I've gotten pretty good with Excel. But that's
only using one worksheet. I need to import Data from one worksheet to another. Here's what I want to do. I want to go to one of the Cells on Sheet 1 and type in a name, we'll say Jerry, for example. When I type in Jerry, I want that to trigger all the cells in that row to input certain information. Let's say the boxes are titled: last name, email, telephone #, and office. On sheet 2 I already have everyone's info. Is there a way to do this? I hope this isn't to confusing. Thanks for any help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputing information from one worksheet to another
Hi,
In generally that's quite easy to do but without seening dour data layout it's difficult to be too helpful but lets try, Assume you type Jerry in A1 you could have this formula in B1, C1 etc =IF(A1<"",VLOOKUP(A1,Sheet2!A1:D19,2,FALSE),"") =IF(A1<"",VLOOKUP(A1,Sheet2!A1:D19,3,FALSE),"") As soon as A1 has something in this will look at a table on Sheet 2 in the cells A1 - D19 (you can change that). It will look for Jerry in column A of that table and if it finds ot return the value from column 2 which would be a piece of information relating to Jerry. Change the 2 to a 3 and you get column 3 returned etc. Mike "Coug4482" wrote: In the last month, I feel I've gotten pretty good with Excel. But that's only using one worksheet. I need to import Data from one worksheet to another. Here's what I want to do. I want to go to one of the Cells on Sheet 1 and type in a name, we'll say Jerry, for example. When I type in Jerry, I want that to trigger all the cells in that row to input certain information. Let's say the boxes are titled: last name, email, telephone #, and office. On sheet 2 I already have everyone's info. Is there a way to do this? I hope this isn't to confusing. Thanks for any help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputing information from one worksheet to another
Mike, I hope you can give me a hand with this thing. Can I send you copy of
what I'm trying to do? "Mike H" wrote: Hi, In generally that's quite easy to do but without seening dour data layout it's difficult to be too helpful but lets try, Assume you type Jerry in A1 you could have this formula in B1, C1 etc =IF(A1<"",VLOOKUP(A1,Sheet2!A1:D19,2,FALSE),"") =IF(A1<"",VLOOKUP(A1,Sheet2!A1:D19,3,FALSE),"") As soon as A1 has something in this will look at a table on Sheet 2 in the cells A1 - D19 (you can change that). It will look for Jerry in column A of that table and if it finds ot return the value from column 2 which would be a piece of information relating to Jerry. Change the 2 to a 3 and you get column 3 returned etc. Mike |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputing information from one worksheet to another
You can upload a copy here
http://www.savefile.com/ and post the link Mike "Coug4482" wrote: Mike, I hope you can give me a hand with this thing. Can I send you copy of what I'm trying to do? "Mike H" wrote: Hi, In generally that's quite easy to do but without seening dour data layout it's difficult to be too helpful but lets try, Assume you type Jerry in A1 you could have this formula in B1, C1 etc =IF(A1<"",VLOOKUP(A1,Sheet2!A1:D19,2,FALSE),"") =IF(A1<"",VLOOKUP(A1,Sheet2!A1:D19,3,FALSE),"") As soon as A1 has something in this will look at a table on Sheet 2 in the cells A1 - D19 (you can change that). It will look for Jerry in column A of that table and if it finds ot return the value from column 2 which would be a piece of information relating to Jerry. Change the 2 to a 3 and you get column 3 returned etc. Mike |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputing information from one worksheet to another
http://www.savefile.com/files/1505487
This is an example and a small piece, but the only part I'm having problems with, now. I actrually have a few more cells, but I think if you can show me how to do it, then I can modify it. Thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputing information from one worksheet to another
Have a look at your file
http://www.savefile.com/files/1505548 Mike "Coug4482" wrote: http://www.savefile.com/files/1505487 This is an example and a small piece, but the only part I'm having problems with, now. I actrually have a few more cells, but I think if you can show me how to do it, then I can modify it. Thanks |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputing information from one worksheet to another
Wow, thats awesome. Thanks. I appreciate it greatly
Brian "Mike H" wrote: Have a look at your file http://www.savefile.com/files/1505548 Mike "Coug4482" wrote: http://www.savefile.com/files/1505487 This is an example and a small piece, but the only part I'm having problems with, now. I actrually have a few more cells, but I think if you can show me how to do it, then I can modify it. Thanks |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputing information from one worksheet to another
You welcome and thanks for the feedback
Mike "Coug4482" wrote: Wow, thats awesome. Thanks. I appreciate it greatly Brian "Mike H" wrote: Have a look at your file http://www.savefile.com/files/1505548 Mike "Coug4482" wrote: http://www.savefile.com/files/1505487 This is an example and a small piece, but the only part I'm having problems with, now. I actrually have a few more cells, but I think if you can show me how to do it, then I can modify it. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
Using information from one worksheet, to rename inserted worksheet | Excel Worksheet Functions | |||
inputing data using vba | Excel Discussion (Misc queries) | |||
Inputing variables | Excel Programming | |||
Inputing Data | Excel Programming |