Killen
03-06-2012, 10:37 AM
I'm sure this is easy for some, but for me...... :banghead:
I keep drawing a blank.
Ingredients:
Sheet 1 and Sheet 2
Columns F and G in Sheet 1
Columns B and C in Sheet 2
Columns J and K in Sheet 1
All data is manually entered (copy/paste) from an ERP resource.
I want a VB program to compare F and G to B and C and alter Columns J and K if there is a match between F and G to B and C.
Eaxmple on sheet 2:
Operation Number.. Part Number
450....................... 06393-10002-SF1
310....................... 5311079SK01
100....................... 5311247SK01
If there is an exact match in the columns noted (Row with 450 / 06393-10002-SF1) on Sheet 1, I want the cell in Columns J and K in that same row to change to 0
Upload of document keeps failing. But I have started this learning experience using the i,j idea....
I keep drawing a blank.
Ingredients:
Sheet 1 and Sheet 2
Columns F and G in Sheet 1
Columns B and C in Sheet 2
Columns J and K in Sheet 1
All data is manually entered (copy/paste) from an ERP resource.
I want a VB program to compare F and G to B and C and alter Columns J and K if there is a match between F and G to B and C.
Eaxmple on sheet 2:
Operation Number.. Part Number
450....................... 06393-10002-SF1
310....................... 5311079SK01
100....................... 5311247SK01
If there is an exact match in the columns noted (Row with 450 / 06393-10002-SF1) on Sheet 1, I want the cell in Columns J and K in that same row to change to 0
Upload of document keeps failing. But I have started this learning experience using the i,j idea....