Hi there, i need a hand please
See attached sample data.
I have a list of coded cost cells (worksheet EXP) which i need to consolidate into monthly totals (worksheet Totals)
I need the corresponding code costs(sheet EXP, Col G and H) to add together according to date (sheet EXP Col F) and show in the correct monthly expenditure column on the totals sheet.
I've been chipping away at this for a while but I'm not really getting anywhere so any help would be much appreciated.
Thanks.
Sample EXP.xls
Bookmarks