[Tonygets]

Hi,

I have the automation working now however there are a couple issues.

1) Issue 1 is that if a value is not found there is a windows popup saying 'cannot find xxx value' and this is halting the automation and causing an error.

2) Issue 2 is that when the value in 1) cannot be found the automation is writing the corresponding value next to the previous value instead of moving to the next column and writing 'No match' in column K.

3) There is a 'pause' entered at the end of each lookup - does this need to be there?

4) The automation is writing a 1, 2, 3 etc in column K and not the 'no match value' - I am not sure what these numbers are for?

Thanks and regards,

Anthony