If column A's value is within the range of Column B and C then copy column's D and E7s Va

in this project i have to check column's A value between Column B and Column C. If columnA's values>= Columns B value or Columns A value<= Columns C value then i need to copy column d and e values and need to put into sheet1 column G and H. Column A is in sheet1 and Column B, C, D and E in sheet2.

I am sorry with my wordings i know its difficult to understand. If someone can help me with this i would be forever grateful. Thank you



A-----B----------C-------------D ----------------------E

1 1 9 Dog Naruto

11 10 19 Cat one piece

21 20 30 Duck lo


i want the outcome like this

A-----------G-------------------H
1-----------Dog---------------Naruto
11----------cat -------------One piece
21----------duck-------------lo
1------------Dog-------------Naruto
31---------------------------
2-----------Cat -------- -one piece




i want to do this in vba

Hello getsomex,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.