Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Status
Not open for further replies.
1 - 4 of 4 Posts

·
Registered
Joined
·
2 Posts
Not 100% sure what you're aiming to do: do you mean you want to replicate and display, in Sheet 1, the current value returned by a formula that's in a cell in Sheet 2?

If that's the case, then don't try to copy the formula as it would reference the corresponding cells in Sheet 1 rather than Sheet 2 (as you've probably discovered).

Instead, link the Sheet 1 cell to the relevant Sheet 2 cell using a simple reference formula:

1. Type an = sign in the desired cell on Sheet 1.

2. Activate Sheet 2 and click in the cell whose formula you want to refer to (this is termed the precedent cell).

3. Press Enter.

If the Sheet 2 formula is in cell D12, for example, the Sheet 1 formula will read: =Sheet2!D12

Hope that covers it.
 

·
Registered
Joined
·
2,702 Posts
You can link from one cell/worksheet/workbook to another. So if you have a formula in A1 of Sheet2, you can use =A1 anywhere else on Sheet2, or =Sheet2!A1 anywhere on Sheet1 to duplicate the output of the formula. But it's not clear if this is what you're after. If you need something more complicated, send more details.

HTH,
Andy
 
1 - 4 of 4 Posts
Status
Not open for further replies.
Top