Hi,
I am trying to use an array sub to run through a table of data, pick out the rows that meet a certain criteria and then unload that summary data to another table.
I have attached a very simple table and example to show the before/after scenario. The number of rows to be read is dynamic, not set.
I have created a COUNTIF cell in L6 to help me get the size of the output array. If there is a way to not include that step then that would be most appreciated.
I am also not sure if the range has to be selected as a whole then needs to be split to be placed in the respective cells in the final table.
I have multiple versions of what I think could have worked but obviously none have so I apologise for the dogs breakfast below. I just want to show that I at least tried
But basically it is:
Many thanks in advance.HTML Code:
(PS. I am struggling to attach the file. I will log out and try again)
Bookmarks