Summary

[josros60]

hi,

i do a spread sheet every month for every employee expenses, how can i have accumulated data for every month for each employee so will upto date anmount expenses.

like a summary spread sheet that will keep running total for each employee.
thank you

Jose

 

[udprocks]

Hi josros,

Can you please upload a sample file say some example of data with expected result,

 

[josros60]

Hi
Here it's a sample file.

As you can see i do it every month and there's a summary sheet, so link to the details one, and i have vlookup function on both sheets when type employee id place last name and first name and code 79 and also and the summary one i link the employee id.

But i wonder if there's a way to automatically by employee id to have spreadsheet that adds amount every month for each employee (like a database sheet)

Thanks for your help

Jose