Change "base table" for each tab differently

[MikeJohn]

Hi,

I have different excel files with different names for each column. e.g.

Excel1:

Col1, Col2, Col 3

Excel2:

Kol1, Kol2, Kol3

Now i do have some Graph which uses the column of Excel1.

I now want to create a second tab and only copy and paste the graph and tell him "all formulars and everything is the same, but use Excel2 as your source".

A general idea would be to import both excels like this:

Excel1:

Col1 as C1, Col2 as C2, Col 3 as C3

Excel2:

Kol1 as C1, Kol2 as C2 , Kol3 as C3

ANd than have somewhere some option to tell him "in this tab, use Excel1 as base table" "in that tab, use Excel2 as base table".

Is that somehow possible?

[settu_periasamy]

Hi @MikeJohn ,

if it is kind of same data, i suggest that, you can concatenate all the excel data into single table with the 'Source Origin'.

e.g.

Final:

Col1 as C1, Col2 as C2, Col 3 as C3,

'Excel1' as Origin  From Excel1;

Concatenate(Final)

Kol1 as C1, Kol2 as C2 , Kol3 as C3,

'Excel2' as Origin From Excel2;

So, you can create a single chart.  In the Sheet Activate trigger, you can use the field 'Origin'.

goto first tab,  'On Activate Sheet' trigger -> Select In Field ->

Field : Origin     

Search of String : Excel1

Like all other tabs.  'On Leave Trigger' -> Clear Field -> Origin