M
maurice broring
Hi All,
Can someone please help me out on the following.
two sheet are identical. (same amount of colums with same headers)
sheet 1 has statusses of orderid's (orderid's are in column A, rest of
data in column B:AE)
I run a macro that collects data from other sheets and external files
The Data is placed in an empty "statusses" sheet (sheet 2), starting
with orderid's in column A, rest in B:AE
Now I need a code that checks in column A sheet 2, starting at row 2
and searches in sheet 1 the whole column A for a identical orderid.
If found, then it copys the entire row from sheet 2 to sheet 1
(overwrites row in sheet 1 the orderid (which is the same) with all
data in de cells behind B:AE)
When ready or if not found the same orderid it checks the next row
(column A) in sheet 2.
Thank you in advance for helping me out.
Regards,
Maurice
Can someone please help me out on the following.
two sheet are identical. (same amount of colums with same headers)
sheet 1 has statusses of orderid's (orderid's are in column A, rest of
data in column B:AE)
I run a macro that collects data from other sheets and external files
The Data is placed in an empty "statusses" sheet (sheet 2), starting
with orderid's in column A, rest in B:AE
Now I need a code that checks in column A sheet 2, starting at row 2
and searches in sheet 1 the whole column A for a identical orderid.
If found, then it copys the entire row from sheet 2 to sheet 1
(overwrites row in sheet 1 the orderid (which is the same) with all
data in de cells behind B:AE)
When ready or if not found the same orderid it checks the next row
(column A) in sheet 2.
Thank you in advance for helping me out.
Regards,
Maurice