This question is for RRJha ONLY, I have another question same exact thing but this time instead of the A,B,C,D,E it will be counting the numbers that are in the columns BB,BC,BD,BE,BF and plsace the frequency of the number found in the BK,BM,BO,BQ,BS ill attach file http://ge.tt/6iNyuXs/v/0
RRJha to answer only I edited my question to better understand. I want to be able to select data in a range BB,BC,BD,BE,BF that is 5 columns, and 35 rows down, and once selected, run a macro that would search the data and count for example: 6, and return how many times it shows up in the BB column range; then place this frequency in the BK6 column into row 98, So I want the macro to go through all of the numbers 1 through 35 place whatever is found in the selected BB column then once these are done move to the next column BC and to BD then to BE then BF
yes, BB column 1 to 35. so each column will have its own search. then do search in BC then BD, then BE, then BF.
Thanks, so the search in BB, the number 6 appears 6 times and so the frequency of six will go into the BK column row 98.
ok it works! now will this still work as I make room for more data buy copying and pasting to make more room above data?
cool! Thanks again. When I have more questions I will send you them to you. job well done!
its always 35 rows. the one i used today
BB 83 TO BF 117
ok, It works again Thanks!