Hi,
I'm using the NL table function to retrieve full table data from multiple companies in different sheets in excel:
=NL("Table";Parameters!C7;;"DataSource=";Datasource;"Company=";"X")
=NL("Table";Parameters!C7;;"DataSource=";Datasource;"Company=";"Y")
=NL("Table";Parameters!C7;;"DataSource=";Datasource;"Company=";"etc")
I need to retrieve the company name as an extra column to use in Pivots, anyone a clue how to fix this?