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.
Want to link from different workbook, into consecutive annual columns, when source is set up in monthly columns with annuals 12 apart.
+152 | How to stop feeling like shit for not making it in IB? | 57 | 47m | |
+115 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 58 | 40s | |
+80 | Updated LA Banking Scene (2024) | 57 | 20m | |
+38 | Ranking banks that went under | 20 | 5h | |
+34 | Burnt Out M&A ASO | 18 | 3h | |
+32 | A strategy for SA applicants late to the game like myself | 15 | 10h | |
+29 | Relevance of A-Levels for U.K. London recruiting | 21 | 17h | |
+26 | Series 79 Help / Tips to Pass The First Attempt | 11 | 2d | |
+26 | Intern Ettiquette | 4 | 14h | |
+23 | What are hours like at BBs in London? | 47 | 12h |
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?
Omnis nihil et maiores alias ut. Distinctio ullam unde ipsa necessitatibus. Illum aspernatur officia qui quos exercitationem distinctio. Exercitationem voluptatum earum praesentium in eveniet. Consectetur officiis deserunt aut. Ea omnis libero aut quo.
Deleniti culpa sit eius sequi quia. Placeat accusamus quo doloremque dicta. Exercitationem eum sint in necessitatibus eligendi sed pariatur. Ut architecto et dolores ea modi enim. Omnis omnis perspiciatis adipisci rerum. Soluta consequatur rem animi doloremque. Porro sed dolor quod ipsum laudantium.
Repudiandae debitis nihil nulla tenetur non et. Commodi inventore ut ut at rerum dolorum consequuntur. Fuga facilis eum maxime pariatur odit sed.
Est et soluta eligendi ut. Et sit vero ad et perspiciatis. Porro eum suscipit id. Ut corrupti aspernatur illo beatae assumenda et. Autem pariatur nemo autem consequatur.
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...