Hello!
I need a formula which can scan through about hundred sheets and count in specific area the cells which contains "small". and then put the number in a list. Hope I made myself understood, thanks for any reply!
Ossa
Hello!
I need a formula which can scan through about hundred sheets and count in specific area the cells which contains "small". and then put the number in a list. Hope I made myself understood, thanks for any reply!
Ossa
It will be good if you explain with the help of a sample file.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Of course, sorry. Attached is a sample. The two sheets with names, are two of hundred which I have in my original. Thanks for reply!
Where is the data for "small" in the 1st 2 sheets?
it will be entered in column A
Do you want the data to show up in the "sizes" sheet?
yes, so that i can see how many uses f.ex medium
Have a look here for a suggested formula and sample:
http://www.xl-central.com/count-sing...le-sheets.html
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks