Search worksheet

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

Originally Posted by 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

better it would be if you attach a sample workbook here with your data.

Hi, if you zipped an example of the workbook then attatch it to a new post we will be able to help better

Here's a site that will show you how to compress your file

http://www.inf.aber.ac.uk/advisory/faq/90


once you have compressed your file, attatch it to your next post by clicking on the paperclip icon, above

Originally Posted by robj83

Apologies.

Thank you

see the attached and let me know if it is same as you requried.

Hi Starguy, thanks for the help, unfortunately its not what I’m after.

I no longer need the description, so that’s one less to worry about.

I am looking to total the quantities of a part number from each worksheet.

I have edited the xls file to be a little more like the one I'm using.

What I need is a function to search for every instance of the part number CA-MC-0013 and then add the Quantities of that part (the number in the C column) together.

Thanks

Rob

Originally Posted by robj83

Hi Starguy, thanks for the help, unfortunately its not what I’m after.

I no longer need the description, so that’s one less to worry about.

I am looking to total the quantities of a part number from each worksheet.

I have edited the xls file to be a little more like the one I'm using.

What I need is a function to search for every instance of the part number CA-MC-0013 and then add the Quantities of that part (the number in the C column) together.

Thanks

Rob

ok see the attached file.

you can also use 3D reference style to get the results.

see the attached file and search Excel help for following words.
About cell and range references