excel programming-copying data from one sheet to another

[hnnn]

Excel Programmers out there:

I have got a workbook with two sheets.

sheet1 gets data from sheet2 e.g

a2 in sheet1 will get data from shee2!a2

But sheet2 is filtered. What I want is that when I select a record randomly in sheet2,a2 in sheet1 should be populated automatically. Whatever a record selected in sheet2,a2 in sheet1 should be filled/copied,when selecting another record the previous record should be cleared and bring in the newly selected one.

Please help with the code.

Thanks .

 

[IRstuff]

Student posting is not allowed

TTFN

FAQ731-376
Chinese prisoner wins Nobel Peace Prize