Trace Precedents Function

"After you work on Wall Street it’s a choice, would you rather work at McDonalds or on the sell-side? I would choose McDonalds over the sell-side.” - David Tepper

11y

Oreos:
ctrl [

Ctrl [ will take me to A1 on '2010'. How can I get it to take me to B1 on the '2009' sheet?

The formula for clarification is in A2 or whatever on '2010'.

oreos

11y

if the element that is on the sheet that the function isn't on is first in the formula ctrl [ works (but obviously only for simple formulae), other than that shit outta luck from my end.

"After you work on Wall Street it’s a choice, would you rather work at McDonalds or on the sell-side? I would choose McDonalds over the sell-side.” - David Tepper

11y

Is it even possible to do?

http://macabacus.com/macros

Not not a boutique

11y

Download this:

Just the lite version is sufficient. The shortcut to trace precedents is (using the Macabacus keyboard shortcut) is: Ctrl Shift [

This will open a little box showing all precedents on any page in your workbook

Authored by: Certified Corporate Finance Professional - 1st Year AssociateCertified Corporate Finance Pro

11y

I presumed I had to download a macro. Thank you very much!

Earnest Money Contract

wookie102

11y

I just F2 the cell, copy the '2009'!B1 part (shift + ctrl + left arrow), then hit F5 and paste. Then to go back to the original tab, just hit F5 then enter.

You can do this very quickly and you don't have to rely on a macro.... Something you may not have say when you have an LBO test at a PE shop or you are using a different computer at a client site, etc, etc

Authored by: Certified Private Equity Professional - 1st Year AnalystCertified Private Equity Pro

11y

Voluptatem laborum provident vel commodi et consequatur velit. Quo commodi aut dicta iste blanditiis quaerat. Impedit assumenda qui cum tempora. Velit omnis rerum suscipit reprehenderit nesciunt voluptates. Quis veritatis dolor enim hic porro. Ratione maxime non itaque culpa ea eligendi deserunt.