Autofill a dynamic Table 2 with a dynamic Table 1? (Criteria-based)

[YourBroLucas]

Howdy dear Excel specialists,

This is my first time on any Excel forums. I've tried to look at other threads before posting this one, yet I don't seem to be able to apply it to my own situation, nor can I understand a thing of that VBA witchcraft.

So I have this main table that regroups all transactions made by any department, put in chronological order.

I would now like to autofill per-department tables in other sheets, with transactions having the sole criteria of belonging to a specific department.
Yet I wish to copy the entire row of 15 columns.

As nobody knows the amount of transactions throughout the year, the tables have to be dynamic.
As such, and considering how little I know about VBA, it comes to my understanding that I can't rely on functions alone and that there shall be a certain portion of macro learning.

I know similar threads exist out there, but I struggle to find a discussion that deals with dynamic databases.

Since there are some crafty excel enthusiasts out here, I wondered if you had some of those tips most mortals can't even dream of possessing.

With my undying gratitude,
Love from France ♥,

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.