How to copy row frm 1 sheet to another depending on the value [Closed]

Report
-
Posts
4
Registration date
Saturday November 8, 2014
Status
Member
Last seen
November 8, 2014
-
Hello,

I am a beginner to this area of VBA coding. I wanted to know how can i copy a row from 2nd sheet (Sheet2) to first sheet (Sheet1) depending on the value i enter in a cell in Sheet1.

Ex., If i have students details in Sheet2 as :-

Student Id Student Name Address
-----------------------------------------------
01 ABC Street 1
02 DEF Street2
03 GHI Street3




And i have a table in Sheet1 as :-


Student Id Student Name Address Status
--------------------------------------------------------------




So if i enter/select Student Id in Sheet1 from the drop down list, then it should take the 2nd & 3rd fields (Student Name and Address) data corresponding to that Student Id from Sheet2.

Anybody's help would really be appreciated here ..

Thanks in advance :-)

1 reply

Posts
4
Registration date
Saturday November 8, 2014
Status
Member
Last seen
November 8, 2014

Helo

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!