I am given a work sheet and have to sort the data into multiple categories, put each category in its own workbook and then add a difference of + or - £10 into a worksheet within the workbook.
I have attached a file which hopefully explains better.
The actual file I have has thousands of entries so I would prefer the process to be as automatic as possible.
Weeks run from Sunday to Saturday
The file I have uploaded was completed online however I normally use Excel 2010 (no idea if this makes a difference I have a severely average knowledge of Excel)
Thanks
Bookmarks