Hello,
I am quite a newbie and have looked through many previous posts and not quite found what i am looking for, so here goes:
I have 6 sales people who all fill in a spreadsheet once a week. each workbook is called SAT then their name eg SAT Dan, SAT George etc. once they have filled this in they email it to me. what i want to do is be able to take all the data from one worksheet of each of their workbooks and have a sum total of their achievements. how do i do this? i know it will be quite simple to most but i have tried the excel help and got more confused than when i forst started!!
thanks in avdvance
Dan
Bookmarks