Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
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.