• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Help?

A

Ajayjati25

New Member
Sir ji Need Help
if we want to Moves between Various sheets by using sheet name, Is it Possible?
Suppose we have file Containing 25 sheets Name A,B,C,D to Y respectivly, I want to Move Move diretly On Sheet naming R From Sheet naming A or Vice Versa.
Is it possible.
 

Attachments

  • Move.xlsx
    44.6 KB · Views: 2
Hi ,

Another option , though it may not be useful in your case , since all tab names are very short ones , is to right-click on the tab navigation icons / buttons on the lower left corner , where you have the 4 tab navigation icons / buttons , signifying First Tab , Next Tab , Previous Tab , Last Tab.

Right-clicking on any of the above 4 icons / buttons brings up a list of worksheet tab names ; clicking on any one takes you to that tab.

Narayan
 
Hi ,

When ever there are special characters in a worksheet tab name , you must enclose the name within single quotes ; thus , to move to a tab named F Forms , you will have to enter 'F Forms'!A1.

Narayan
 
Dear Sir,
I am attaching a file which contains the some serial nos in cells. Now I want to Count the serial nos at end of each row. But I need count of those serials who have not Colored (Green or Feroze Blue)

Also Please guide me how to take count of Texts
 

Attachments

  • Samyang Stock Serial Nos.xlsx
    22.7 KB · Views: 2
Sir
Please find attached herewith Sheet which contains texts in 4 Colums
I need Count of Each Column in 6Th Row. As it is text count function is Showing Zero count.
 

Attachments

  • Example.xlsx
    7.4 KB · Views: 2
You must log in or register to reply here.
Back
Top