Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Applescript for Excel trouble
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="MWile" data-source="post: 1686871" data-attributes="member: 364584"><p>I have an Excel file that was output from FileMaker. It has 715 rows and 7 columns. I'm new to Applescript. I'd like to write a script that will to through the rows of the first column and if it finds data, duplicates the row and then removes all the info in the last 7 columns from the row. In other words, if there is the word "Text" in the first column, it would duplicate that row and delete the info in the last six columns. I would then end up with the word "Text" on a line by itself.</p><p></p><p>I just can't seem to get anything to work. Is there an easy way to accomplish this with Applescript?</p></blockquote><p></p>
[QUOTE="MWile, post: 1686871, member: 364584"] I have an Excel file that was output from FileMaker. It has 715 rows and 7 columns. I'm new to Applescript. I'd like to write a script that will to through the rows of the first column and if it finds data, duplicates the row and then removes all the info in the last 7 columns from the row. In other words, if there is the word "Text" in the first column, it would duplicate that row and delete the info in the last six columns. I would then end up with the word "Text" on a line by itself. I just can't seem to get anything to work. Is there an easy way to accomplish this with Applescript? [/QUOTE]
Verification
Post reply
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Applescript for Excel trouble
Top