markpem
12-15-2014, 09:52 AM
Hello
I currently have two sheets (sheet1 and sheet2) with duplicate data in, however in sheet 1 some columns are
filled and blank and in sheet 2 some columns are filled and blank. I need some vba code to enable me to click a
button to:-
Match the case number on sheet 1 and sheet 2 and then on sheet 2 any data that is in a cell that either does not
exist in sheet1 or is different to sheet 1 to update sheet1. Once updated to delete the matched data in sheet 2.
in sheet1 I have data in columns like this
(a) Case Number - (b) Client (c) User - (d) Date ...... (i) outcome
in sheet 2 I have a data like this:
(a) Case number (b) [blank] (c) User (d) Date... (Everything else is blank here)
so for example:-
Sheet 1
(a) (b) (c) (d) (I)
12345 Mr Smith Timothy Jones 15/12/2014 Completed
sheet 2
(a) (b) (c) (d)
12345 Jake Peterson
In sheet 2, the update is now that Jake Peterson has taken over but I do not want to copy the data in B as it's
blank and it will overwrite
Rather than doing a paste row it would have to be a paste cell as I do not want any data like (i) overwritten either.
Please note that sheet two will always have the case number in (a) to enable a match.
Could anyone help me please!
I currently have two sheets (sheet1 and sheet2) with duplicate data in, however in sheet 1 some columns are
filled and blank and in sheet 2 some columns are filled and blank. I need some vba code to enable me to click a
button to:-
Match the case number on sheet 1 and sheet 2 and then on sheet 2 any data that is in a cell that either does not
exist in sheet1 or is different to sheet 1 to update sheet1. Once updated to delete the matched data in sheet 2.
in sheet1 I have data in columns like this
(a) Case Number - (b) Client (c) User - (d) Date ...... (i) outcome
in sheet 2 I have a data like this:
(a) Case number (b) [blank] (c) User (d) Date... (Everything else is blank here)
so for example:-
Sheet 1
(a) (b) (c) (d) (I)
12345 Mr Smith Timothy Jones 15/12/2014 Completed
sheet 2
(a) (b) (c) (d)
12345 Jake Peterson
In sheet 2, the update is now that Jake Peterson has taken over but I do not want to copy the data in B as it's
blank and it will overwrite
Rather than doing a paste row it would have to be a paste cell as I do not want any data like (i) overwritten either.
Please note that sheet two will always have the case number in (a) to enable a match.
Could anyone help me please!