Forum Discussion
Need help retrieving data from table and adding it to one of 8 variables
Hi Dylan03
looking at your table setup, the easiest way would be using a Pivot table. Just select the source table and then goto menu "Insert | PivotTable"
You can place it on a new worksheet or on the existing one:
Then just drag and drop the PivotTable Fields:
Company to the rows
Rate to the columns
Total to the values
And that's it.
You only need to refresh the Pivot table with a right-click and "Refresh" whenever new records are added to the source table:
Hi Dylan03
looking at your table setup, the easiest way would be using a Pivot table. Just select the source table and then goto menu "Insert | PivotTable"
You can place it on a new worksheet or on the existing one:
Then just drag and drop the PivotTable Fields:
Company to the rows
Rate to the columns
Total to the values
And that's it.
You only need to refresh the Pivot table with a right-click and "Refresh" whenever new records are added to the source table:
