D
Dave
Hello all and thank you in advance for any help that you can provide me.
I have 2 excel worksheets that have the same column headings. Worksheet A
is an older worksheet that doesn't have any updated information. Worksheet B
is an updated worksheet. There are about 40 columns in both worksheet but
both worksheets have a unique record number (Column AE). What I need to be
able to do is this.
In worksheet B I need write a function that will search in Column AE of
worksheet A and B and append to worksheet B any unique records that are not
already in Worksheet B.
I hope this isn't too confusing and I hope this can be done.
I have 2 excel worksheets that have the same column headings. Worksheet A
is an older worksheet that doesn't have any updated information. Worksheet B
is an updated worksheet. There are about 40 columns in both worksheet but
both worksheets have a unique record number (Column AE). What I need to be
able to do is this.
In worksheet B I need write a function that will search in Column AE of
worksheet A and B and append to worksheet B any unique records that are not
already in Worksheet B.
I hope this isn't too confusing and I hope this can be done.