copy data from one sheet to another

[MATT.B]

I have 2 workbooks I cant give example of WB1 at this time
workbook 1 is a collection of data for the entire day
workbook 2 (WB2.xls) is a list of updates for that day
so I want to search WB1 "sheet1" column G for the number located in column C of WB2 if the number is found I want it to add to WB1,"sheet1" column K if its waiting on 1,2,3, or update depending on what section the update is in. then I want it to add the text from comments (column E) to column K as well
so when tha macro is ran it will look at the number in column C on the example find it in column G of the other workbook then add waiting on 1 and the contents of the comments section but it cant replace the data that's already in column k it need to append to it
can this be done?

WB2.xls

[MATT.B]

I have 2 workbooks I cant give example of WB1 at this time
workbook 1 is a collection of data for the entire day
workbook 2 (Attachment 442993) is a list of updates for that day
so I want to search WB1 "sheet1" column G for the number located in column C of WB2 if the number is found I want it to add to WB1,"sheet1" column K if its waiting on 1,2,3, or update depending on what section the update is in. then I want it to add the text from comments (column E) to column K as well
so when tha macro is ran it will look at the number in column C on the example find it in column G of the other workbook then add waiting on 1 and the contents of the comments section but it cant replace the data that's already in column k it need to append to it
can this be done?

Attachment 442993

WB1 "BACK LOG" not "sheet 1
and here is an example WB1.xls

[MATT.B]

so far I have this

Please Login or Register  to view this content.

where I'm having troubles is how to go from C4 to C5 to C6-C16 there are more but its in different locations on the same sheet I can just modify the code to work for each section

and how to lookup varC coordinates in wb1.xls and how to use that in place of what I have

[MATT.B]

Solved
will post solution later