Help on VBA Code when calculating SUMIFS

[Hellodoublev]

Hi All,

I would like to know on how to write VBA code for SUMIFS on multiple worksheets. Please see the attached example.

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.

Can anyone please help me with a VBA code to produce such results?

Thank You.

 

[rahulshewale1]

hi @Hellodoublev ,

See if it is ok ?
Power Query Solution.


Regard
Rahul Shewale

 

[Hellodoublev]

hi @Hellodoublev ,

See if it is ok ?
Power Query Solution.


Regard
Rahul Shewale

Hi!

Thank You so much for your help.