Excel Question - Link different workbook

Want to link from different workbook, into consecutive annual columns, when source is set up in monthly columns with annuals 12 apart.

WSO Elite Modeling Package

  • 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
  • Elite instructors from top BB investment banks and private equity megafunds
  • Includes Company DB + Video Library Access (1 year)

Comments (10)

Sep 4, 2013 - 3:08pm

do offset(source,0,((column($A$1)-column(A$1))*12), this means that every time you drag it one cell right it will be grabbing 12 cells right in the source.

This to all my hatin' folks seeing me getting guac right now..
Sep 4, 2013 - 3:57pm

What's the problem? Might have to make this in to an indirect.

This to all my hatin' folks seeing me getting guac right now..
Sep 4, 2013 - 3:58pm

Oh snap, switch the 12 to -12, that'll give you the right number.

This to all my hatin' folks seeing me getting guac right now..
Learn More

300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.

Learn more
Sep 4, 2013 - 4:39pm

When I drag it to the right it's just returning the next number over from the source. What should be my first number in there that you labeled "source"?

Sep 4, 2013 - 4:46pm

it should be the cell address of the first annual number you want to grab from the other sheet... a link to the #. then when you drag the formula right, for every cell to the right of that it should grab the next number in that other workbook 12 columns over..

This to all my hatin' folks seeing me getting guac right now..
Sep 4, 2013 - 8:55pm

What if I have semestral revenues, but I want to calculate yearly revenues in another tab.
I also need to drag a formula, but I couldn't find the right combination of offset.

It's basically the same exact problem as OP, but with two cells rather than 12.
Can someone help out?

Sep 4, 2013 - 10:40pm

toarch:

What if I have semestral revenues, but I want to calculate yearly revenues in another tab.

I also need to drag a formula, but I couldn't find the right combination of offset.

It's basically the same exact problem as OP, but with two cells rather than 12.

Can someone help out?

Did you bother to look at the formula and comments?

Start Discussion

Total Avg Compensation

April 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (32) $350
  • Associates (180) $232
  • 2nd Year Analyst (102) $151
  • 3rd+ Year Analyst (25) $146
  • Intern/Summer Associate (95) $145
  • 1st Year Analyst (387) $131
  • Intern/Summer Analyst (315) $82