/
Retrieve information from AARO to Excel

Retrieve information from AARO to Excel

Owned by Julia Ratniece
2022-03-14

When the relevant formulas and data cells have been completed, information is retrieved from AARO to Excel via the AARO Reports tab in the Retrieve Formulas group.


Retrieving AARO formula data

The user can then choose one of the buttons:

Button

Action

Retrieve All

Retrieve data into all open Excel workbooks from AARO.

Retrieve sheet

Retrieve data into the open Excel worksheet from AARO.

Multiple sheets

Retrieve data into multiple Excel worksheets from AARO. In this scenario, the user is presented with a choice of worksheets he or she would like to retrieve.

If the user choses Multiple sheets, they will see the next dialog where sheets to be retrieved have to be chosen.

Explanations for how to use the dialog boxes are provided within the Excel dialog boxes to guide users through the necessary steps. An example for retrieving a data for a couple of open worksheets is referenced below:


Retrieving multiple sheets