Working with External Data

[GB]

Hi I have a worksheet that gets data from an external source and populates a worksheet as a table. Each time I extract my data from the external source the number of rows change.

Next to the table I have 2 columns that contain formulas which reference the table data.

What I am trying to do it have the 2 columns extend to the same row as the table to its left to keep my calculation dynamic along with the table range. Any ideas would be helpful.

regards
GB

 

[Jake Collins]

Dear GB

Make the 2 columns part of the table

 

[xlstime]

Hi GB,

Hope headers name does not change and those are unique name, if yes, than you can use get column address using match function and than you can make your formula dynamic.

Hi I have a worksheet that gets data from an external source and populates a worksheet as a table. Each time I extract my data from the external source the number of rows change.

Next to the table I have 2 columns that contain formulas which reference the table data.

What I am trying to do it have the 2 columns extend to the same row as the table to its left to keep my calculation dynamic along with the table range. Any ideas would be helpful.

regards
GB