multi sheets

This works for the sheet it is on =COUNTIFS(H:H,"PFIZER",I:I,">=1/1/20") need a total count from all my sheets. I can get it to count one value but not if i need it to look at two. sheets are listed in column A. A1:A52

I am struggling with my code- and will admit that I am a newbie to VBA. Yes- I have reviewed a ton of posts and dont seem to be able to fix my code. It seems that no one else has an answer to the multiple sheets question. :confused: I am trying to extract rows that meet a specific value...

Hello i have assigned a task like copy the entire values of one excel to another excel file when clicking a macro button, is there any kind of vba code for that ??? thanks in advance

When I save an excel file who contains 20 or more sheets in excel 2010, it creates a few new files, tabstrip and stylesheets etc.. When I open the webpage in browser(s), the selected tab of the tab strip remains the same color, I want to change this, so the user always see what tab is selected...

This forum has already helped me to add a macro to protect and unprotect all the sheets in my work book. The one piece of the puzzle I am now missing is the ability to quickly change the range which is left open to be edited in all the sheets at once. Currently I can now protect and unprotect...