Loop to transfer a row of values to another sheet based on value on one Cell

Hi everyone,

I'm trying to transfer the corresponding data from one row to another sheet, based on the chosen value in one cell in the destination range. I have attached a sample workbook explaining this. Thank you very much!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Yes, sorry alansidman, I forgot that!

Thank you jolivanes, I appreciate your good will and extra help, and in fact, the code I ended up using is the one of your Maybe_A macro because although I have to admit that I preferred the one I had, given that it adapted itself to any named range as opposed to having to modify the column number in With sh1.Cells(i, 5) and the cell reference for the date With sh1.Range("D8"), I placed the one I had it under the Private Sub Worksheet_Change(ByVal Target As Range) with the conditional If Target.Address = "$G$7" Then, but it got an error while Maybe_A ran smoothly there. Just in case you want to have a look at it and perhaps find what it is that doesn't let it run under Private Sub Worksheet_Change(ByVal Target As Range);

Please Login or Register  to view this content.

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)