hello all!

this is my first post here, i`ve been dabbling in VBA coding for simple and medium macros, but right now i really need some help. here`s what i`m trying to do:

find a range of cells in some sheet, based on the string in column "B" then, i want all the values in the range E-P (in the "infosheet" tab) to be copied to a summary sheet in a range C-M (sheet "summary sheet 2" in the example). i know, it sounds vague, but i will attach an example workbook, to clarify things.

once i get this down, i am sure i can tweak it to do the same for some other totals i need in yet another sheet ("summary sheet 1")

please bare in mind that the range of the source table (sheet "infosheet" in the example) is dynamic (might have 70 rows this month, 60 or 80 next month).

any kind of helo will be greatly appreciated.

cheers!!

examplesheet.xlsx