Search Worksheet and show in table amount

[Tamster]

Can you search a workbook for a specific item in a row or column? I know I can use find and type in a name in the row or column, this will show duplicates in the workbooks. I don't want to have to search and type every single one if I don't have to. I want to be able to place them in another folder, so I can tell how many of a particular item is sold, during the course of the year.

Thanks for the help in advance!
Tamster

[Bruno Campanini]

Originally Posted by Tamster

Can you search a workbook for a specific item in a row or column? I know I can use find and type in a name in the row or column, this will show duplicates in the workbooks. I don't want to have to search and type every single one if I don't have to. I want to be able to place them in another folder, so I can tell how many of a particular item is sold, during the course of the year.

Thanks for the help in advance!
Tamster

I think the solution is trivial... in fact you did not specify where exactly
to find the item, so I searched all rows AND columns...
Some adjustment might be required.

Bruno