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
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