I've been trying to do a program to add data from a forms to an specific format in an excel. What I came up with was to update a row with the data that has been inserted in the forms, in a different sheet that's hidden, so that the specific cells where I need them in the format can copy them by using a formula.
The problem i've been having is that whenever it converts the file to PDF and sends it to myself via mail, it usually converts it with the values that were before the update row, like if it didn't update it in time, but when i'm testing and watching the excel while it's updating, it changes almost instantly. I tried adding a delay just before the convert file, and watching how it responds, and it works sometimes, but only when the value is >1 minute.