Search worksheet

[robj83]

I am in no way a coder nor do I know any functions for excel other than those taught at school, but if someone could help me with this little problem I would most appreciate it.

Thanks in advance.

Rob

Ok.

I have an excel spreadsheet with several worksheets that have a part number, description and the quantity of that part.

I would like a function to search the whole workbook for an instance (i.e. part number) then total the quantity of that part into a new cell on the master sheet.

Like SearchWorkbookFor(CA-GM-0001) AddTheValueOf each instance

I would also like a separate function to search for the part number and copy the description for the part into the mastersheet's description column.

I apologise for the crappy code but I just wanted to make it clearer.
I also have a sample xls file if it would help

Thanks again

Rob