Hi All,
I have a 2250 cells with sumifs formula. Can somebody please help me to create a sumifs vba alterative that I have built for 2250 Cells.
Need to get the sum of work hours for each work ticket for each Employee.
my data is about 20 thousand rows and just 3 columns.. DATA is growing.
I want to place the answer to worksheet 2 from N to AB Column.
worksheet 2 Row N3 to AB3 is the Criteria for Employee
worksheet 2 Row B4 to B150 is the Criteria for work ticket
Worksheet 1 A3:D20000 is the source data
Worksheet 1 A3:A20000 is the Employee Rows
Worksheet 1 B3:B20000 is the work ticket Rows
Worksheet 1 C3:C20000 is the work hours I need to sum
please help.
I have a 2250 cells with sumifs formula. Can somebody please help me to create a sumifs vba alterative that I have built for 2250 Cells.
Need to get the sum of work hours for each work ticket for each Employee.
my data is about 20 thousand rows and just 3 columns.. DATA is growing.
I want to place the answer to worksheet 2 from N to AB Column.
worksheet 2 Row N3 to AB3 is the Criteria for Employee
worksheet 2 Row B4 to B150 is the Criteria for work ticket
Worksheet 1 A3:D20000 is the source data
Worksheet 1 A3:A20000 is the Employee Rows
Worksheet 1 B3:B20000 is the work ticket Rows
Worksheet 1 C3:C20000 is the work hours I need to sum
please help.