This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to output data to a specific file, specific worksheet, specific table (Table 2) in this worksheet. I am able to achieve it all except for outputting to the table.
The workflow I have
1. Firstly, create multiple copies of the template based on the number of employees in a particular month with employee id as a filename
2. Then, based on employee id, workflow outputs data to each file, goes to a specific worksheet "Data point", and paste that employee data from cell A2 to AE15000. AF2 to AL2 has formulas.
I have an issue with step 2. I am trying to have my workflow output data to the tablein the excel file.
When I used to do it manually, I copy and paste data in excel and it automatically converts (resized) to table, hence, formulas in column AF to AL were working. With workflow, I am able to output but its not within the table, hence formulas in column AF to AL not working.
Also, when I open the file after workflow runs, I am getting an error