Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

bernie72

macrumors newbie
Original poster
Sep 22, 2010
1
0
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
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.