excel :copying data from one sheet to another

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.see attachment,i want the yellow cells in sheet1 to be filled each time i select any record in sheet2

Please help with the code.

Thanks .
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!