Issue with indirect formula

[richard1234567891011]

Hi, guys,

I am using this formula in order to copy data from another worksheet.

=INDIRECT("'[EU_Export costi immobiliari.XLSX]Sheet1'!G2")

Now I need to pull dow this G2, but obviously I can't now with this formula. I think I need to add in this formula something with the row, something like (ROW()-3)*1;0). But I don't know how to add it.

So, I need a formula like this: =INDIRECT("'[EU_Export costi immobiliari.XLSX]Sheet1'!G2") to pull down in order to catch also the other data down.

Thank you guys,

 

[James006]

Hello,

Your general objective is clear ... but you are not precise enough :wink:

=INDIRECT("'[EU_Export costi immobiliari.XLSX]Sheet1'!G" & "2")

The portion "2" is to be replaced by whatever calculation is required to get 2 transformed into your target row number ...

Hope this will help

 

[richard1234567891011]

Hello,

Your general objective is clear ... but you are not precise enough :wink:

=INDIRECT("'[EU_Export costi immobiliari.XLSX]Sheet1'!G" & "2")

The portion "2" is to be replaced by whatever calculation is required to get 2 transformed into your target row number ...

Hope this will help

Thank you James, But I don't want to replace it manually. I have a Lot of data to replace otherwise. I need a formula to pull down.

 

[Peter_SSs]

Can you explain exactly why you are using INDIRECT?
Where is the G2 that this formula contains?

 

[James006]

Could you explain how 2 is to be transformed ...???


=INDIRECT("'[EU_Export costi immobiliari.XLSX]Sheet1'!G" & ROW()-3)

 

[richard1234567891011]

Could you explain how 2 is to be transformed ...???


=INDIRECT("'[EU_Export costi immobiliari.XLSX]Sheet1'!G" & ROW()-3)

G2, G3, G4 and so on.

 

[richard1234567891011]

Can you explain exactly why you are using INDIRECT?
Where is the G2 that this formula contains?

I am using indirect because the two files will be moved inside the server of the company. In this way if both are opened they will not lose the link.

 

[Peter_SSs]

I am using indirect because the two files will be moved inside the server of the company. In this way if both are opened they will not lose the link.

What about my second question?

 

[James006]

G2, G3, G4 and so on.

In which cell is your formula located ...???

 

[richard1234567891011]

What about my second question?

ah sorry, G2 is inside the sheet 1 in the second file, where I need to the data, [EU_Export costi immobiliari.XLSX]