gdps
05-20-2020, 06:43 PM
Greetings everyone!
I have a manual task that I need to do every week in excel and I believe it is possible to solve it through VBA, but I have 0 knowledge about it.
Every Friday I have to update the columns "Previsto" and "Realizado" with the percentage of several initiatives in a table (around 200).
Is it possible to create a macro that, depending on the date column that is selected, I click on a button and it makes a VLOOKUP of the Previsto and Realizado values?
I'm suggesting the VLOOKUP function, but I don't know if it would be the best option. I believe that a conditional will also be necessary.
Any thoughts? : pray2:
26710
I have a manual task that I need to do every week in excel and I believe it is possible to solve it through VBA, but I have 0 knowledge about it.
Every Friday I have to update the columns "Previsto" and "Realizado" with the percentage of several initiatives in a table (around 200).
Is it possible to create a macro that, depending on the date column that is selected, I click on a button and it makes a VLOOKUP of the Previsto and Realizado values?
I'm suggesting the VLOOKUP function, but I don't know if it would be the best option. I believe that a conditional will also be necessary.
Any thoughts? : pray2:
26710