If Cell is "x" Then Copy Cells to New Spreadsheet

Scripting Forums AppleScript | Mac OS X
#1

Hi Guys,

I have been poking around Google to find a way to do this, however all I could find is VBA which doesn’t run in the newest Excel for Mac.

What I want to do is create a few AppleScripts that can copy data from one spreadsheet to another within the same workbook. I have a worksheet called “Full List” that contains all the details of all my RSVPs for a conference coming up, with a series of check boxes to assign what they will be attending, accommodation, flights, etc. etc. I need to create several smaller lists from this for print, giving to suppliers, etc. The verbal description of what I was to do is:

There are other variations on this for creating attendee lists for particular functions within the conference as well, however they will all be variations of this basic theme.

How do I go about this? I tried automator, but it has no ability to do IF statements, so that is out, and I couldn’t find samples to really work out how to use IF and copy/paste with Excel, so am not really sure how to tackle this.

The VBA version I found can be referenced online at [url=http://en.allexperts.com/q/Excel-1059/Find-copy-Paste.htm]http://en.allexperts.com/q/Excel-1059/Find-copy-Paste.htm[/url]

I guess the easiest way to run this is form the scripts menu, or something like that? however wherever it has to be is fine (even script files that are manually run is cool). If manual, I would like to add one line to the top of the document that lists the last date/time stamp when it was run for auditing purposes.

Cheers all! If there are resources I should poke around at, please point me to them.

Model: MAcBook Pro 2.33GHz | 2GB RAM | OS X 10.5.6
AppleScript: 2.0.1
Browser: Safari 525.27.1
Operating System: Mac OS X (10.5)

#2

Thanks for this, but I have some queries to confirm that I can get this going correctly.

First off, where do I put the script when it is written in order for it to show up in the Excel scripts lists?

Secondly, I noticed that you have listed the case as:
if v1 AND v2 or V3, can I change this to if V1 or V2 or V3 are X then copy? will this allow any x to copy the whole row? And do I need to set anything to ensure it doesn’t override old information?

Cheers!