The InXL GetData option will allow this and it will be necessary to have a Data Connection set up for this.
β
Once the Data Connection is set up, please follow the steps below:
In the Access InXL tab, click Get Data (left hand end of the ribbon)
Select the Dataset as required.
Choose the Period and Year.
Use Next to set Criteria.
When the Lookup Selector is opened for the item, it is necessary to click Display to return available values.
Use the Arrows to select/deselect items and then Select to save the options.
Click Next to select Nominal Attribute options in the same way as the criteria above.
Click Get Data to return the information to Excel.
The Data sheet shows the information returned.
ReportDefault offers the space to create reports based on it eg Pivot tables or similar.
