Checking Against Excel List via QM

[philipq]

Thanks Gintaras, I will look into that part.

Now, in continuation to the above program, after I obtain the odd data to be replaced from Excel, I need to go to the column B cell in the same row.
All I have is the found Array variable.
Can I refer back to the Excel Address of this found arrray and thus offset to the corresponding rows B cell in Excel?
Or is there a better way to achieve all this like a total database route in QM?

The basic raw Algorithm of what I want to achieve is as below:
1) Goto cell G1 of sheet("VCC Release")
2) Start checking each cell downwards in G(dynamic) against master data in sheet("Data") column M:M(dynamic)
3) If there is an odd data, not mentioned in master list, then goto the column B in Excel of the corresponding odd data cell.
4) Take the data in B and find the correct data from CRM (separate long procedure - 2nd part I can do myself)
5) Replace the G column odd data in Excel with obtained correct data.

Kindly point me in the right direction in relation to my above last attempt.

Thanks,
Philip
Thanks

Best Regards,
Philip