Excel 2007 : How to copy data from one sheet to another corresponding to same rows in both sheets?

[badesh]

Hi there,
I need to copy column datas from one sheet to another. For example in attached, I want to copy the date from column E of sheet 2 to sheet1 column D with corresponing ID rows. Another example is: the row2 has same name in both sheet. And I would like to copy the termdate of sheet2 to row2 of sheet1.
I am sure it is doable for master people.
Thanks for your help.

[badesh]

Hmmm, looks like I am out of luck. 'Cause no one has responded to my problem.

[arlu1201]

I guess you are talking about column D of sheet 2 and not column E.

You can use vlookup for this. Are you familiar with using vlookup?

[badesh]

Yes arlu1201. My bad. But you got my point. I am not familier on vlookup. Thanks for responding.

[arlu1201]

When i check your data, the data in Column A of Sheet1 has 0 before the number and a yellow diamond with the asterisk sign on it. Select the whole column, then click on the dropdown near the diamond and select -> convert to number. The leading 0s will disappear. This is to ensure that column A in Sheet1 and Sheet2 match exactly. Otherwise the vlookup wont work.
Then put this formula in Sheet1 column D -

Please Login or Register  to view this content.

Put this formula in D2 and drag down to the rest of the column. Then paste special values.

[badesh]

Dear arlu1201,
Thanks for responding so quick to my querry. I get it, Thank you so much for your help saving my big time.

[badesh]

Dear Arlu1201,
One last question. What does represent by 4 in the formula?

[arlu1201]

In the range that you have selected (2nd parameter of the vlookup) - Sheet2!A:D, you want the data in column D which is the 4th column.

If your range was B:D, then D would be the 3rd column, so you would have to use 3.

Does this explain it?

[badesh]

That is what I was guessing but just wanted to make sure myself. Thanks, that does explains a lot. Thanks again and have a good time.