automatic fill with external references

asked 2018-08-26 09:58:48 +0100

fabio61 gravatar image

I need to use a few spreadsheets with one sheet for every client. I want to introduce the references to their cells into a new file. Then, on the new file I will have

as the reference to the B4 cell in sheet 1 of my file1

How can I compile a column changing the reference only to the sheet?

I need to have a series with

='file:///home/utente/file1.xls'#$Foglio2.$B$4 ='file:///home/utente/file1.xls'#$Foglio3.$B$4 ='file:///home/utente/file1.xls'#$Foglio4.$B$4

and so on.

Nonsono riuscito a trovare un modo ma sono sicuro che ci deve essere un sistema senza dover riempire a mano cella per cella

edit retag flag offensive close merge delete