G
Guest
I have two worksheets in a workbook. I want to populate some columns in
sheet1 from data in sheet2 based on data in both sheets. There are a lot
more records in sheet1 then sheet2. For example
Sheet1:
RSE BM EM N O P
01K4 0 2.5
01K4 2.5 5
01K13 0 1.2
01K13 1.2 3.2
01K23 0 1.7
01K23 1.7 2.2
01K23 2.2 3.6
Sheet2:
RSE B C D E
01K4 3.2
01K13 1
01K23 1.3
01K23 2.7
I need some code that will look at Sheet 2 row by row and if the RSE value
is equal to Sheet 1's RSE value and Sheet 2's B value is between or equal to
Sheet 1's BM and EM value, then the values in columns C, D, and E from Sheet
2 get pasted in to the coresponding N, O, and P columns in Sheet 1. I was
thinking a loop with some sort of if statement might work? thank you
sheet1 from data in sheet2 based on data in both sheets. There are a lot
more records in sheet1 then sheet2. For example
Sheet1:
RSE BM EM N O P
01K4 0 2.5
01K4 2.5 5
01K13 0 1.2
01K13 1.2 3.2
01K23 0 1.7
01K23 1.7 2.2
01K23 2.2 3.6
Sheet2:
RSE B C D E
01K4 3.2
01K13 1
01K23 1.3
01K23 2.7
I need some code that will look at Sheet 2 row by row and if the RSE value
is equal to Sheet 1's RSE value and Sheet 2's B value is between or equal to
Sheet 1's BM and EM value, then the values in columns C, D, and E from Sheet
2 get pasted in to the coresponding N, O, and P columns in Sheet 1. I was
thinking a loop with some sort of if statement might work? thank you