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.