GET data from and send data to tables and columns added in a financial period
- Open the page in the financial period you want to pull table data from, and selectExport.
- Next, in Excel, place your cursor in the#Ready to pullarea of the table data you want to pull, then go toWorkpapers,Retrieve Data,Retrieve Selected Data. You can add additional data in the spreadsheet, if needed.
- Place your cursor on the #Ready to push are of the table data, then go toWorkpapers,Send data,Send selected datato push the new data into the template. New rows get added to the table.
- And lastly, go to Statutory Reporting and refresh your page to view the imported information into the table from your Excel spreadsheet.