Hello!
I am hoping one of you may be able to help me..
i have lots of data in different sheets, and i basically need to do the below process:
I beleive you can use ~"for each" record.. then loop through etc..
If value in sheet (GB).range B:B, is equal to sheet (alll Cases).range(B:B) value...
Then see if GB.range (O:O), is equal to (All Cases) range(H:H) on the same row.
If they are both equal, then copy sheet(All Cases).range(I:R) to that row in GB where they match.
If they are not equal, then move to next record and loop through all the way.
For Example...
If Sheets(GB).Range(B2).value = Sheets(All Cases).Range(B34).value then
Check if Sheets(GB).Range(O2).value = Sheets(All Cases).range(H34)
If both contain equal value, then
All Cases.Range(I34:R34).Copy
and paste into GB.Range(Q2:Z2)
I am hoping to get this in a loop to check every value in GB(B:B) against ALL Cases(B:B), if the value in GB(B2) doesn't appear in All Cases(B:B) then just move onto next value..
I hope that makes sense, I apologise for the mixed style of the above, but i am trying to make it more clear!
Bookmarks