Much appreciate your help.
I have a spreadsheet with products listed in rows and details of the products in the columns.
I am trying to get excel to find a product code within column A and then paste the corresponding value that is already in the clipboard (from fake) into Column C. I am using the following script:
tell application "Microsoft Excel" set searchRange to range ("A1:A5") set foundRange to find searchRange what "AM100" with match case set fRow to first row index of foundRange set myData to value of range ("B" & fRow as text) set theClip to the clipboard as text
end tell
I can't seem to make the paste happen in column C on the same row where the product code has been found.
Please help...
Many thanks Darryl