I need help to ompare two exel tables looking for identical values.
The rungs of two columns are texts and numbers, and among these are the ID codes (example: Xf86Gfs).
I need the program to extrapolate these codes from the columns, compare them and return the result of the comparison, for example:
The line A1-D (example) of excel contains the following text
"Transfer with id: Xf86Gfs"
After the program has extrapolated the code it compares it with the second excel sheet, looking for "Xf86Gfs".
At the end of the comparison, the program must give me the result of the comparison:
a) the compared rows that contain the identical code.
b) the lines of sheet 1 that do not have identical values in sheet 2
it is possible that in a row there are two values to be extrapolated and compared, for example:
The A1-D line of excel contains the following text "Transfer with id: Xf86Gfs on behalf number M45ssKL"
in this case I want the program to extract two codes: "Xf86Gfs" and "M45ssKL"
How does the program extract these codes?
Or the programmer suggests it or by following the procedure below:
1) Select the first row of column X
2) Extrapolate the text in search of the words that precede the code to compare, so if the sentence contained in the line is "Transfer with id: Xf86Gfs on behalf number M45ssKL", then the program must look for the word "Transfer with id:" and then select the 7 words / number / symbols that follow
3) In this way the code "Xf86Gfs" will be processed
4) Repeat steps 1-2-3 for all lines.
I wait for serious and interesting proposals for a long-term collaboration, thank you.
64 фрилансеров(-а) в среднем готовы выполнить эту работу за €107
Dear Employer, I have read your requirement and I will do your job. Please message. I am an excel expert and will do the job for you. Please do try me once!! :) Thanks and Regards, Ash
hello I am an excel-vba expert and I can finish your project so fast start the chat I am ready to start.........................................................................................
Hi, I am having good knowledge on excel,micros and VBA module development. Please come on freelancer chat to discuss many more on this project as I am able to do the same.
Dear Sir, We have specialised and dedicated team for Microsoft excel, powerpoint and word as well, you can discuss further whatever you want specifically for excel. Looking forward! Kami