VBA to copy data from multiple cells between sheets

[Hazman_08]

I have a workbook with 2 sheets. Sheet1 has range D19:I22. Sheet2 has range E5:J8. What I want to do is have data entered into one cell copied to a specific other cell on the other sheet, and vice versa. For example, Sheet1 D19 copied to Sheet2 E5, or Sheet2 E5 copied to Sheet1 D19. I think this would be a Worksheet_Change of some sort. Can someone please tell me if/how this can be done?

 

[Hazman_08]

I spoke too soon. On the second run onwards, I get a "Copy method of Range class failed" error

 

[Hazman_08]

Glad we got there in the end

I spoke too soon. Worked once, then started giving Copy method of Range class failed error

 

[kevin9999]

OK. Here's a link to the file I created to test the code: hazman.xlsm
It uses the exact same code I provided in post #2.
Any value entered into the range D19:I22 on sheet 1 gets copied to its corresponding cell in range E5:J8 on sheet 2.
Any value entered into the range E5:J8 on sheet 2 gets copied to its corresponding cell in range D19:I22 on sheet 1.
If you can't get it to work, then I'll need you to share your file for me to interrogate to determine what's going wrong - if you want me to look at this again.