Good day all, 
I hope I can gain some assistance from you guys in relation to this subject.
I have a dynamic data feed into excel (cell references a1 to h1).
The width of this data feed is static. However the depth differs, because the feed has 3 parts, and each part can be a different depth, depending on the amount of rows contained in each part of the data feed.
I cannot segregate the data feed into 3 separate entities.
I have some cells immediately to the right of this feed. These cells have formulas and formatting in them that relate to the corresponding rows in the data feed in each section.
My problem is that when the data feed updates and displays a large amount of data in any section, my cells containing the formulas and formatting to the right of the feed becomes mis-aligned with the corresponding row of the data feed, and the formula references loose their source/target.(Absolute referencing does not fix this problem).
Is there a way I can lock my cells on the right to each data feed section so they align to the corresponding row in the data feed?
Example:
To start with:
first data feed contains 10 rows.
second data feed contains 10, and
third data feed contains 10 rows.
When the data is updated, i could have section 1 with 15 rows, section 2 with 9 and section 3 with 12. I want my formulas and formatting to shrink and/or grow with the depth of each section.
I hope I explained it Ok? Please assist if possible..
I hope I can gain some assistance from you guys in relation to this subject.
I have a dynamic data feed into excel (cell references a1 to h1).
The width of this data feed is static. However the depth differs, because the feed has 3 parts, and each part can be a different depth, depending on the amount of rows contained in each part of the data feed.
I cannot segregate the data feed into 3 separate entities.
I have some cells immediately to the right of this feed. These cells have formulas and formatting in them that relate to the corresponding rows in the data feed in each section.
My problem is that when the data feed updates and displays a large amount of data in any section, my cells containing the formulas and formatting to the right of the feed becomes mis-aligned with the corresponding row of the data feed, and the formula references loose their source/target.(Absolute referencing does not fix this problem).
Is there a way I can lock my cells on the right to each data feed section so they align to the corresponding row in the data feed?
Example:
To start with:
first data feed contains 10 rows.
second data feed contains 10, and
third data feed contains 10 rows.
When the data is updated, i could have section 1 with 15 rows, section 2 with 9 and section 3 with 12. I want my formulas and formatting to shrink and/or grow with the depth of each section.
I hope I explained it Ok? Please assist if possible..
