Part of my job involves creating new articles. Each article is stored inside a spreadsheet and has an article number in cell A and a name in cell B.
The only reason I ever need to open the spreadsheet daily is to create a new entry into a new row.
Is there a way I can do this remotely, without having to have the application open? I run on a Mac, and we have the crappy 2011 Office Excel which is dog slow. Could I link this a small program to allow me to perform basic operations?
What about if I got rid of the spreadsheet all together and used a small database, and gave each article it's own entry?
I am just getting the feeling that spreadsheets are not a very modern way for storing lots of information.
I am up for using tools such as Hazel or Keyboard Maestro to heavy automate the process.
I would love a second opinion on this.