Cumulative weekly table, wanting to make entry easier

[vamplew987]

Hi! Been a little while since using Excel properly, and in need of some help. Want to make a spreadsheet to manage staff performance. I can download a report every week that gives me the numbers for each staff member but I don't necessarily have the same staff working every week. Is there a formula/way of making entry easier, where I can enter the report in on say a separate sheet every week, and then it automatically matches the data to each staff member in the cumulative table. Would be great if it would automatically add the new names in too when new staff start.

Any help would be very appreciated, many thanks, Tom

 

[dreid1011]

If you are going to overwrite the entry sheet every week, then no, there is not a formula option that will keep a running total. You would need to use VBA if I understand correctly.

 

[Skyybot]

Sounds like Power Query is the route you want to take.

 

[vamplew987]

Sounds like Power Query is the route you want to take.

Thank you, how do I go about that?