Automator and Excel data.

Discussion in 'Automator' started by ChipFromGA, Oct 11, 2018.

  1. ChipFromGA

    ChipFromGA New Member

    Joined:
    Oct 11, 2018
    Messages:
    1
    Likes Received:
    0
    At work, I have to fill in many numbers on a daily bases. Most of them are redundant and are the same each day. But one column changes each day.



    [​IMG]



    The first column is the one that always changes, the second is always left blank, and the third and fourth are always zeros.



    I have done a script for the third and forth columns.



    [​IMG]



    I know I can just use brute force and make 7 different days of this. But I figured I could use something like excel to copy and paste or use variables in Automator? I have searched online and everything that I can find and understand talks about going from a site to excel, and not excel to a site.



    Any suggestions on how to make this easier?



    Thanks

    Chip
     
    ChipFromGA, Oct 11, 2018
    #1
    1. Advertisements

  2. ChipFromGA

    Cory Cooper Moderator

    Joined:
    May 19, 2004
    Messages:
    6,044
    Likes Received:
    199
    Hello and welcome.

    Sorry, that's above my experience level with Automator/AppleScript. Try the folks over at MacScripter to see if they can lend a hand.

    Let us know how that goes,

    C
     
    Cory Cooper, Oct 28, 2018
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.