Today I decided to see how advanced automator is by trying to get it to do a tedious task of taking certain information from one workbook and putting it into a new workbook. I am not copying all of the information out of the workbook so I tried selecting a certain column and was able to paste that first column into a newly created workbook but was not able to to go back to get more information from the last workbook to then put into the newly created workbook. please let me know if this is possible in automator or If I would have to learn apple script to do this task. a little sample code/automator process would be nice to help me.
Thanks for the help!
Thanks for the help!