Howdy, Stranger!

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

Categories

Welcome to the new platform of Programmer's 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 its 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

kaka2000kaka2000 Posts: 1Member
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.