BrutalDawg
02-06-2017, 11:36 AM
I have two sheets, sheet1 and sheet2.
I have trying to come up with a macro that loops through each row in sheet1 and subtracts sheet1!I from sheet2!F if Sheet2!A2=Sheet1!E2 & Sheet2!D2=Sheet1!H2 until 0 and then find the next row in sheet2 where Sheet2!A2=Sheet1!E2 & Sheet2!D2=Sheet1!H2 until there is 0 remaining on sheet1.
Hope the attachment helps.
Note, some items on sheet1 will not correlate with anything on sheet2
18265
I have trying to come up with a macro that loops through each row in sheet1 and subtracts sheet1!I from sheet2!F if Sheet2!A2=Sheet1!E2 & Sheet2!D2=Sheet1!H2 until 0 and then find the next row in sheet2 where Sheet2!A2=Sheet1!E2 & Sheet2!D2=Sheet1!H2 until there is 0 remaining on sheet1.
Hope the attachment helps.
Note, some items on sheet1 will not correlate with anything on sheet2
18265