Excel Excel - keeping the links when entering data int a cell

H

honeymar

Joined
May 5, 2006
Messages
1
Reaction score
0
To Whoever can help,

currently i have 2 sheets with 2 cells on one and 1 on another that i have linked using a circular reference & Paste Special. all the cells need to display the same information which can be entered from any of the 3 cells. The issue i am having is that when you enter data into anyone of the cells it removes that cells link from another cell.



So when i enter data into one of the other cells the original cell won't update, its essential that you can enter data from any of the cells they all update no matter how many times you change the data. If anyone can help i would be most greagrateful>
Marc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
Excel Msgbox runing beyond posted cell range. 1
Excel How to add numbers in same cell? 2
Excel Typed text appears in wrong cell 0
Last Modified By in a cell by user 3
Excel Need assistance with modifying a Duplicate declaration. 13
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Top