Hi,
i have a many worksheets in which each cell contain either "Yes" or "No". I want to write a macro which counts number of "Yes" in each corresponding cell (for example in A1 cell ) in all worsheets and put the answer to a new worksheet(for example NumberOfYes) in the corresponding cell (that is A1). A template excel file is attached for clarification of query.
Regards,
Tehseen
Bookmarks