isohwa.blogg.se - Excel 2013 for mac trace precedents on another sheet

So by using the same procedure, here you can also see the total dependent cells and go to them accordingly. Now go to VBA 1 You can see that the Tracing Arrow that we have seen in Method 1 has also appeared here.

Here, in the figure below, the Code has brought us to cell C5 of the VBA 2 You will see that you have been taken to a dependent cell of C5.Now select cell C5 on VBA 1 sheet and run the Code by clicking the Play button shown in the figure by pressing.You should have a new window like this.Ĭode: Sub Trace_Dependents_Another_Sheets()ĪctiveCell.NavigateArrow TowardPrecedent:=False, ArrowNumber:=1, _.You can also go to the Developer Tab and Select the Visual Basic Press Alt+F11 for Windows (for Mac press Opt+F11 or Fn+Opt+F11) to open VB editor window.Now to run the Code, follow the steps below: Before proceedings, let’s rename Sheet 1 and Sheet 2 as VBA 1 and VBA 2, respectively, for our convenience. You can also apply a VBA code for tracing dependent cells. Run a VBA Code for Tracing Dependents on Another Sheet

Read More: How to Trace Formula in Excel (3 Effective Ways)Ģ.

In this way, we can check dependent cells for any cells in a workbook, even if the dependent cells are on the other sheets.

As a result, we have landed on C5 of sheet Trace Dependent 2

This will take you to your referenced dependent cell.

Now, click on any of the three references to go to that reference, and then click OK.

In the box, we can see that cell C5 has 3 dependent cells on the sheet Trace Dependent 2.

Now, bring your mouse pointer to the pointing line and double-click on the mouse’s right button.

Now you should see an arrow emerging from C5, pointing toward an icon like this below.Now go to Formulas In the Formula Auditing Group, select Trace Dependents.Select any cell for which you want to trace dependent cells.Now, follow the steps below for tracing dependent cells. For ease of operation, we rename Sheet 1 as Trace Dependent 1 and Sheet 2 as Trace Dependent 2. Trace Dependents Command is a built-in feature that is very useful when it comes to tracing dependent cells on the same sheet or across different sheets. Use Trace Dependents Command for Tracing Dependents on Another Sheet Now, we will trace the dependent cells on sheet 2 for a cell in sheet 1. On the other hand, on Sheet 2, we have the Average, Maximum and Minimum value of the age on the 1st sheet. Hence, we take an example worksheet where in sheet 1, we have some students’ Names and Ages in a class. In this section, we will demonstrate 2 effective methods to trace dependents to another sheets in excel with appropriate illustrations. 2 Useful Methods to Trace Dependents to Another Sheet in Excel