Dear forum,
Since I am very new to VBA and programming in general i need some help with some VBA code that returns some results based on multiple criterias.
In the worksheet I have attached I want to do the following:
Considering the values in cells A, B and C (story, beam, load names) as the criterias (which I introduce in cells L, M and N) I want to fill the columns O to U with the coressponding values from cells D to J.
The problem is how do I do this so that the code fills multiple rows since results are multiple for the same criteria.
Since I have alot of data that keeps changing and which can be anywhere from 100 rows to 20000 rows I would also like to refill/refresh the result cells whenever dtat in the sheet changes.
I tried an array formula, which I just drag diown, using countifs but it just takes ages for the cells to update when i chage the value of one criteria.
Thank you in advance
Bookmarks