1. Welcome to the new MacRumors forums. See our announcement and read our FAQ

Applescript and Excel

Discussion in 'Mac Programming' started by bernie72, Sep 22, 2010.

  1. macrumors newbie

    #1
    Hi there,

    I am new to Applescript and I am trying to use it to handle a big set of data in Excel. In particular, I would like to use a script that would allow me to search an existing worksheet file for a specific term in column A. If this term is found (e.g. "Peter"), I would like to copy the content of the whole row and paste its content into another worksheet (e.g. A456:C456 = {"Peter", "Smith", "Toronto"}. Could somebody help me with this? I have been searching for a solution all over the place, but I cannot find one.

    Thanks a lot for your help,

    Bernie
     

Share This Page