Good Day all,
Currently I am required to get values from 2 different excel sheets,
lets call them Excel A and B.
On A, it is just a column of numbers. I need to match that value on B, if it matches, extract the whole row of data to be inserted on a 3rd excel file.
For now, what I am doing is getting 2 dt and running a for each row to compare the 2 dt.
I know that even cell colours play a part, I am just not sure how to go about doing this.
So far at the for each loop, there is an error message when i try to compare the 2 dt.
"dtVoteNumber.Rows(“VoteNo”).ToString() == dtFullDetails.Rows(“Vote”).ToString()"
My technical skills with coding are limited, will appreciate any direction you guys can give me.