There is only one method to rearrange worksheets in Excel - drag them to the desired position on the sheet tab bar. When it comes to alphabetizing tabs in a large Excel file, this may be a long and erroneous way. This tutorial shows a couple of time-saving alternatives. Continue reading
Comments page 2. Total comments: 27
i want to copy the headi of main sheet that sheet 01. and paste that heading multyple sheets with numarical order
eg: heading work id 1053(sheet 01) copy this heading and paste this heading in every pages. but the sheet name is renamed automaticaly that sheet 02,sheet 03 sheet 04 etc in every sheets automaticaly..pls help me
I created a table with the letter "G" in certain cells (one column).
I'm trying to get a sum of the number of cells with the letter "G".
Also needing a sum of the cells with the letter "G" that are green in color.
I have tried several samples I found at your website; ablebits.com with no success.
Thank you.
Kimosabe:
Here's how to count the cells that contain "G":
=COUNTIF(A3:A35,"G") where the G cells are in the range A3 to A35.
To count the formatted cells you'll need to look at the above discussion and get the VBA solution.