Forum Discussion

MHulten's avatar
MHulten
Copper Contributor
Oct 27, 2021

Is it possible to create a grid based on dynamic arrays?

I'm trying to create a simple grid that holds referential information between two tables (Person and Resource). The pasted grid below is to give an understanding of what I wish to accomplish.   St...
BI & Data Analysis
Formulas and Functions
MHulten's avatar
MHulten
Copper Contributor
Nov 01, 2021

Riny_van_Eekelen sorry for ghosting you (but it is halloween after all... 😉 ).

My intention is to have the user enter the X'es manually based on the analysis at hand. In other words, there will be no formula that takes care of this work.

 

Using a non dynamic grid (i.e. static text in cells) this is entirely possible, but that would mean having the user perform manual copy and paste, or using a macro when the source ranges change. I want to avoid both of these options.

 

Another option would be to have a table with two columns side by side. Then having listboxes with the ranges as source, where the user can set the relation. But when the ranges grow this option looses in usability. 

 

BR Mats

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Nov 01, 2021

MHulten Sorry, don't really care about Halloween and don't understand what you want to achieve. Perhaps someone else.

Resources