automate process with PDF and excel -- 2
Budget: $10 – $30 USD
I want to automate a process I have to copy the 20,000 most frequent words in English with definition in Spanish and with examples of uses I have a spreadsheet with the following format in a single column first there is a purple cell which is for word number then a cell red what is for English word then a green cell for the Spanish translation and finally 80 blank cells for the examples of use of course not all words have 80 examples but some do and the word number format would be 1.1.1 1.1.2 1.1.3 this is because for a definition there can be several meanings well what I want is and that in a PDF viewer and if it can be done better with adobe acrobat I don't know if it has the option to automate functions and if not With another, what I want is that when I right click, I get an option in the context menu to copy what is selected in a purple, red or green cell, once selected in which cell to link to the document Into excel, then you will have to select between two options: yes, put it in the next empty cell or in which cell number of the excel document to place it, as you will have already noticed, the excel document and the PDF will have to be linked each time you send to a cell of the excel document you will have to save the operation in the excel document