I have a work book which has 2 data entry sheets for each user (more to be added) and one summar y sheet.
On the summary sheet I want the totals from each user to be entered automatically with a formula. The user sheets will expand as more data is entered. How can I have the running totals show on the summay sheet?
Also, how can I have the summary show by monthly totals for each user, since I will have to chart this.
File is attached.
Help is much appreciated.