VBA to tally totals for each user

[banquo_ws]

Hi!

I'm writing here in the hope of leveraging the power of Excel functions which I am not very familiar with. Thank you for your support by the way.

This is likely to be, embarrassingly enough, a simple question...

A sheet where A1 lists Username, B1 lists Job#, C1 list PagesPrinted.
The sheet tracks who prints how many pages, over time.
So, of course, many users have many jobs in there.

Something like...

Username JobNumber PagesPrinted
John 1 10
Mary 2 20
Sam 4 25
John 5 5
John 6 9
Mary 7 3

I need to find an efficient way to tally how many pages each user printed.

So far, I figured out how to hide everything when the user opens the spreadsheet, have the fileopen dialog open to get the : delimited file from the printed, change the : to a ; and massage the data and insert the data into a temporary table. For my skills, I'm rather happy with what I did so far.

I'm sure this is probably easy to do if you know which functions to call, so instead of reinventing the wheel, here I am.

Thank you,

Antoine

[stnkynts]

Simple enough. Could you submit a test worksheet so we have some data to work with. Also, how do you want the results to be reported (i.e. on another sheet, in a message box)