Hello everybody,
I attached a sample file. I have a database (J2:Q24) from which I have to collect some data by multiply criteria.
Example: I have to collect from "value" columns K-M-O-Q the data which meet "criteria" columns E-F.
I solve the gathering with a SUMIF function in array formula (CTRL+SHIFT+ENTER), but it is too complicated and takes a long time in a huge database.
I would like to ask for your help to create a macro for collecting values.
Moreover, the macro should collect all data from database (J2:Q24) which contains the main number (column A) and enything which begins with this number (example 1020; 1020A; 1020B; 1020C etc.)
Please see the uploded sample file.
Bookmarks