in reply to Comparing two excel workbook and copy the values if the cell are match

Hi naga7667,

You probably want to start by storing the content of the Speclis.xls into a hash, with the string (e.g. asd) as key and number (e.g. 25) as value.

Once this is done, you read the Logsheet.xls, retrieve en value of the E column for each row, and lookup into the hash to find the value to be stored in column AU.

  • Comment on Re: Comparing two excel workbook and copy the values if the cell are match

In Section Seekers of Perl Wisdom