New in macro & VBA word - Need help

[Norzak]

Hello all,

I am new in the macro and VBA world, i work to perfect myself in this new Learning. I have a spreasheet to work on and i need a code that can do this ... If anyone can help me doing it please.


I have a spreadsheet that as 3 type of workers ( 43, 48 and 65)(same column A.)
I have 800 lignes to scan

I want to sum all the work hours for each type of workers (Work hours - same column B)

Thanks for the help

 

[kweaver]

Do you really need a macro?
Try this, adjusted for all three types:

=SUMIF(A1:A800,43,B1:B800)

 

[LMacD]

Or you can use a pivot table.

 

[Norzak]

omg ... Thanks a LOT