Inserting information from 3 cells in a worksheet to 3 cells in another workshee

[Bharris]

I have a workbook set up for an Oncall Roster.

Sheet 1

Start Finish Name Mobile Home Phone

27-Feb-13 06-Mar-13

06-Mar-13 13-Mar-13

13-Mar-13 20-Mar-13

20-Mar-13 27-Mar-13

27-Mar-13 03-Apr-13

03-Apr-13 10-Apr-13

Sheet 2

Name Mobile Home Phone

Mickey Mouse 1111 111 111 1111 1111

Donald Duck 2222 222 222 2222 2222

Goofy 3333 333 333 3333 3333

Pluto 4444 444 444 5555 555 555

Barney 4444 444 444 6666 666 666

I want to be able to insert the 3 cells as separate cells from Sheet 2 into the corresponding cells in Sheet 1 without having to retype all the information or copy and paste into the different cells. Sort of like you can in a Drop Down List.

ie: Can I choose Mickey Mouse in sheet one have his mobile and home phone information automatically fill the designated cells?

 

[kaushik03]

Hi Bharris,


Welcome to this forum and we glad to have you here.


I am little confused about your end output.


Couple of questions:


1)What do you actually mean by 'designated cells' here?

2)Do want to the mobile number and home phone to be populated in sheet2 when you select the name (Mickey Mouse)in sheet1? Please clarify.

3)What is the role of start and end date here?


However, it would be great if you could upload your sample workbook here

http://chandoo.org/forums/topic/posting-a-sample-workbook


Looking forward to your response.


Kaushik

 

[Guest]

Wang: illegal.Candid time from May to June 27th.,tom ford handbags
some people are deeply resentful,tom ford handbags,today more than you ..slowly to the water . 2 months after the expiration of the investigation will enter the stage of review and prosecution . ,tom ford handbag, The fire soon burn up .The hotel boss Wang told the Yangtze Evening News ,tom ford bag,she and her husband and two children had symptoms of poisoning ,tom ford handbag,nausea ,tom ford bag,Last Friday.