SUMIFS VBA Code on multiple worksheets

[Hellodoublev]

Hi All,

I would like to know on how to write VBA code for SUMIFS on multiple worksheets. Right now I am using SUMIFS but my data is more than 60000 Rows and using the function SUMIFS is very slow. I need a VBA code to extract the data from worksheet 1 and into the rest of the worksheets by departments.

Example of Raw data is like this :

Document Date	Month	Account Number	Departments	Amount
03/01/2020	1	300000	1010	(82,473.60)
03/01/2020	1	300000	1020	(6,182.00)
03/01/2020	1	500000	1020	(240.00)
06/01/2020	1	500000	1010	(122,162.00)
06/01/2020	1	610020	3020	(23,378.00)
12/01/2020	1	615040	3050	(240.00)
12/01/2020	1	685004	3060	(61,514.00)

My results would be like this :

Can anyone please help me with a VBA code to produce such results (By departments) ?

Thank You.

 

[fred2406]

Hello,

I think you would find an enormous advantage if you used "Get and Transform" instead.

Fred