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...