find "w" instance in column and count within range then change the next "Daily" val.

[rrosa1]

hi p45cal
thanks a lot's u save my day but when i try to run the code it give me error 1004 "select method or range class fail at this line

 mylookin.Cells(i1).Select 'pd

thanks agin for your help