Populating a range from a recordset

[Saintor]

I want to populate a range B2 to the bottom right corner with the show recordset & results.

It is possible for a given Wh & Per that there is no data.

Although the Per in the recordset is YYYY/MM, the title row is actually a date with a custom format to look like YYYY/MM, but the source is date calculated by the substraction of months (example: =EDATE(TODAY(),-2) or 2 months ago)

What would be the best programming approach?

I was able to populate a different column (not shown) for a simple serie of cells.

Please Login or Register  to view this content.

For whatever reason (and time of the day), I am a bit lost to do it in 2D.

ExcelForum2.png

EDIT: I forgot to mention that the warehouses in the column A are not fixed and are there descending by quantity on hand (not shown). I can have a warehouse in the recordset not showing in the table.

[Bob Phillips]

Try this formula

=SUMPRODUCT(--($C$14:$C$38=TEXT(B$1,"yyyy/mm")),--($B$14:$B$38=$A2),$D$14:$D$38)

[Saintor]

Sorry if it was misleading, but I need to populate the table direct from the recordset (as per my title) , not from a copy of the results (row 14-38).

[Bob Phillips]

It would be far simpler to dump the recordset to a sheet, maybe hidden, and use formulas.