|Assuming that you are using Excel, you can "link" cells with a simple formula.|
Let's say you have $100 in Sheet1!A1.
If you enter this is in any cell on Sheet2, it will display $100:
If you enter this, you will see $500:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.