Ok I have no idea how to describe what I need help with.
I have made a 2 sheet workbook and the first sheet is a reference of different 'categories' and 'totals' regarding specific categories.
On the second sheet I have a client details section and I have made a dropdown menu to select which 'categories' refer to them.
What I am wanting to do is for the spreadsheet to automatically copy the reference from the 'totals' on sheet 1 to the totals on sheet 2 when a category is selected on sheet 2 from the dropdown menu. Then for the sheet to add up all the categories totals.
I really do not know how to do it.
This is a copy of the spreadsheet I have at the moment, any help would be greatly appreciated. It is a project I am helping with at the local community centre as they do alot of things by hand and using books to record information, which takes an age to find the information you want.
http://www.sharebigfile.com/file/197573/Book1-xls.html
Bookmarks