Go Back   MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Reply
 
Thread Tools Search this Thread Display Modes
Old Sep 22, 2010, 04:01 PM   #1
bernie72
macrumors newbie
 
Join Date: Sep 2010
Applescript and Excel

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
bernie72 is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
AppleScript: How do I save multiple Excel sheets to one pdf using Applescript sbtaylor1 Mac Programming 0 Oct 28, 2013 11:38 PM
AppleScript: How do I save multiple Excel sheets to one pdf using Applescript sbtaylor1 Mac Applications and Mac App Store 0 Oct 28, 2013 11:32 PM
Applescript to Export text from Indesign and import to Microsoft Excel. alissat Mac Programming 1 Mar 28, 2013 11:21 AM
Applescript. Copy filtered cells in Excel Palkan Mac Programming 2 Jul 3, 2012 10:34 AM
Applescript with Excel tayjayt Mac Programming 1 Jun 27, 2012 05:44 PM

Forum Jump

All times are GMT -5. The time now is 11:38 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC