I wish to know how to dynamically reference to an array in a second sheet.
In sheet 1 I would have an array of width:6 hight:2. I designated a range called ‘myarray’ to reference to this region.
In sheet 2 I then would enter in A1: =myarray and pressing ctrl+shift+enter. This results in the contents of the array being referenced in my second sheet. Alterations to the individual cells in sheet 1 are updated and correctly displayed in sheet 2. When I add a row between my 2 rows in ‘myarray’ in sheet 1, I can confirm that ‘myarray’ now has a hight:3 and encompasses this new range of data. However, this extra row is not outputted/updated in sheet 2. Instead it just shifts everything down 1 row and (correctly) displays only the first 2 rows of my now 3 row array. If I deleted the array in sheet 2 and copy the array again, it does display all 3 rows correctly.
My questions is: How can I make it so that it correctly updates the amount of rows in sheet 2 after inserting a row in sheet 1.
Thank you all in advance.
This is my first question on this forum or forums in general, so if I violated policies in regards to where or how to ask questions, please politely inform me.