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.
Trending Content - Investment Banking Forum
| +86 | [2026 - October] Unbiased Prestige Rankings | 52 | 8h |
| +86 | Who is the final boss in Houston Energy? (GS, JEFF or EVR) | 19 | 6h |
| +71 | You should probably leave IB | 26 | 17h |
| +49 | McK vs A&M Offer Decision | 25 | 2h |
| +45 | Why Do We Turn Comments? | 10 | 1d |
| +43 | Tomorrow Will Be Better | 5 | 3d |
| +41 | Moelis PCA vs Lower tier BB Coverage | 30 | 10h |
| +24 | How much should you ask questions / seek feedback as an intern? | 8 | 23h |
| +23 | UBS IB #24 in US M&A in 2026 | 8 | 12h |
| +22 | UBS’s Investment Bank Is Building an AI Slop Factory | 3 | 1d |
Career Resources
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.
Appreciate it
Well, still having trouble when dragging to the right.
What's the problem? Might have to make this in to an indirect.
Oh snap, switch the 12 to -12, that'll give you the right number.
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"?
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..
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?
Adipisci recusandae enim eaque officia. Vitae nemo aperiam aut perferendis quia nemo delectus. Enim ea animi mollitia est laboriosam quidem ipsum. Dolor sed in et occaecati dolores ut voluptas.
Optio repellat similique quasi quidem quos sed qui. Molestiae laboriosam quae omnis ipsam expedita deleniti nisi itaque. Illo dignissimos dicta dolorum nulla voluptates accusamus eaque. Quam veritatis ipsum aut quia qui.
Deserunt ut autem iste eligendi quas doloribus fuga. Officia et cum perspiciatis dolorem quaerat nesciunt.
Molestiae tempora rerum eligendi voluptas. Omnis laborum quia harum esse dolores laudantium impedit sequi. Cupiditate quam voluptatem fugit placeat ipsa repellat corporis.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...