Hi, I have 2 sheets in my excel... Data and TXN. I need to copy from sheet (TXN) cell B4 and paste in sheet (data) cell A4,and again sheet (TXN) cell B7 and paste in sheet (data) cell A5. I need a loop that would be easy to use. Can anyone advise??