Expand range automatically

[clandestino800]

Hi guys!

I am currently using a report that has some errors in it, so I've created a table with some formulas to "repair" the issues.
The source file changes everyday and the range changes as well. I tried to convert the file with the formulas to a table but that doesn't expand the range automatically.

Is there another way to achieve that other than the table trick (that one isn't working for me)

Thanks

R

 

[GraH]

Google dynamic range formula in Excel using INDEX.

 

[clandestino800]

Yes, I tried the =$A$2:INDEX($A:$A, COUNTA($A:$A)) Formula suggested online before. That's not doing the trick, though.
When the source file gets new rows, the file with the index formula doesn't change a bit.

Maybe I am getting something wrong

 

[GraH]

The source data is an external file?
Then maybe you can use Power Query to import the data. Then do what needs to be done in the target file.
Or show us some sample data you can upload here using the XL2BB add-on.