Core modelling skill 4: How to copy a link

Download the reference fill to practice:

To obtain the worked example file to accompany this chapter buy the financial modelling handbook.

We've already seen how to create a new link.

We don't always have to create links from scratch. If we already have a link to the line item, we can copy that link instead.

In our example calculation block for Electricity generation revenue, the last ingredient we need is the Operating Period flag.

We have already used this to calculate the Seasonality adjustment in row 22.

Rather than create a new link from scratch to the relevant calculation on the timesheet, we can copy the link from Row 22.

Step 1: Select the row

Shift + Spacebar (Native excel keystroke)

Step 2: Copy the row

Ctrl+c (Excel native keystroke)

Step 3: Paste the row in the desired location

Shift+spacebar, Enter (Excel native keystroke)

There are two kinds of links in our model. Local links are links to line items on the same sheet. Imported links are links to line items coming from other sheets. Note that you can only copy local links to another location on the same sheet. You can copy imported links to any other sheet in the model. Imported links have the sheet name in the address, allowing us to copy them to any other sheet. This is one of the reasons we mark imported links with a different font.


Sign in or become a Financial Modelling Handbook member to join the conversation.
Just enter your email below to get a log in link.

Subscribe to Financial Modelling Handbook

Don’t miss out on the latest financial modelling guides. Sign up now to get access to the library of members-only guides.