Issue with indirect formula

richard1234567891011

Board Regular
Joined
Feb 21, 2018
Messages
91
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,
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
The formula is located in the file where I need to take the data. EU_Export costi immobiliari.XLSX is the file with the data. G2 is the cell in the file with the data.

Understand the original source data is located in cell G2 ...

But regarding the destination cell where the formula is located ... which cell is it ...???
 
Upvote 0

Forum statistics

Threads
1,224,840
Messages
6,181,278
Members
453,029
Latest member
provexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top