I agree, Pecoflyer but as a newcomer to Excel, I did try to find the answer to my problem but could not find a solution. That is the reason I joined a forum.
I am a retired electronics engineer and and took over the roll of treasurer a year ago. This was when the accounts were done by hand, by a "Bookkeeper".
I have always thought that Excel was a powerful bit of software and I should use it to bring our Fellowship up-to-date.
So far the system I have created is working fine but I am always trying to improve it.
The data I require has already been inputted in the spread sheet and I thought there must be an easy way of extracting it, rather than putting the same figures in a seperate worksheet.
So any help would be grateful.