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 sheet2!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 data in a2 sheett1 should be cleared and bring in the newly selected one.
Please help with the code.