Create Button For Jump Between Sheets (Excel Tutorial)

Always I m trying to discover something new for Microsoft Excel, because what I am thinking about Excel is “The Creator or Developer of Excel don’t know its range of Usage” (don’t mind developers). Really every time when I try to find something for excel then I seen what are people working on excel and what I am doing on excel…. Mean I find myself nothing in excel. So before I have already discussed with you few Excel Tutorials now another tutorial with Video. In this I will guide you how can we make a button in Excel with the help of Macro to Jump Between sheets.

Excel Macro Jump Between Sheets

Check This Tutorial>> Making 3D Ball – Cristal Ball with Adobe Photoshop (Tutorial)

How to Create Macro to Jump Between Sheets in Excel.

Open Excel > Create A Button>

Create button in Excel

You have create a Button now Give it a simple Name as per your requirement>>

Jump Between Sheets in Excel

Now we have to Assign a Macro for this button> Right Click on Button and Click on Assign Macro

Assign Macro in MS Excel

Give a memorable Name for it and Click on New

Record a New Macro in Excel

After click on new button you screen will redirected to another Program Microsfot Visual Basic. I will tell later about it. Here we have to Inset a Command for Jump to Sheet2

Visual Basic in Excel

This is command you have to insert it between

Sub Jump2Sheet2()
         Sheets(“Sheet1”).Select << this is the command
End Sub

After this you must click on Run as per picture show above..
And Close the window of Visual Basic
You have all done.. Now Go back to Sheet1 and Click on that Button you will be automatically redirected to Sheet2 by clicking that button.
And for your practice you have to make another button with same procedure to Jump Back to Sheet1.

if this video is not working or Youtube is Blocked se this How to Unblock Youtube without any Software or Direct Link of Video 

Still so many tutorials are remaining. so don’t forget to Subscribe us by following network.

Conditional Formula for Two or More than Two Columns (Excel Tutorial)

In this post we will learn about formula which will help us to get abstract quickly. It is very difficult to explain you without video but m trying to show you with images from which we will understand about it. Because once in my career I had also need about this..

excel tutorial conditional formula

Conditional Formula For Two or More than Two Column for Calculation

In simply I can try to explain you about it
See here is picture and you are seeing there are few salesmans and you want to know which salesman has how much sale in targeted area .
For example we want to know Aquib’s Sale in Karachi

In image you seen Aquib sales 2 times in Karachi
Now use this formula to get results:

=SUMPRODUCT(–(A3:A17=”Aquib”),–(B3:B17=”Karachi”),C3:C17)

You will find how much Aquib sales in Karachi

Here I have used only two columns but you can use it more than two columns like if there is any other coloums.

  =SUMPRODUCT(–(A3:A17=”Aquib”),–(B3:B17=”Karachi”),–(C3:C17=”Malir”),C3:C17)

Stay Connected with us now it is just beginning of TIPS and TRICKS.

How To Calculate Age in MS Excel (Tutorial)

Hi Friends, its my first Post regarding Microsoft Excel. MS EXCEL is accounting based program and every body know about it.

excel tutorial date calculation

Formula for Calculating Age in Excel

Today my first post about EXCEL and it is about how we can calculate age in Microsoft Excel this feature was not setup in old version of excel in i.e. Excel 5 , 7 or Excel 97 but its work in Excel 2000, Excel 2003 and Latest versions follow This..
For on only Year: =DATEDIF(A1,TODAY(),”y”) Then Month: =DATEDIF(A1,TODAY(),”ym”) And Days: =DATEDIF(A1,TODAY(),”md”)
Image for ready reference

If you want to calculate your age in text version try this.
For Complete =”Your Age is “&DATEDIF(B1,TODAY(),”y”)&” Years, “&DATEDIF(B1,TODAY(),”ym”)&” Months & “&DATEDIF(B1,TODAY(),”md”)&” Days”
see this

You can change text “Your Age is” into your own text like if there is any product and you have set any expiry date and you can change it in whatever you want