Hi, I have two speadsheets. One with my bank statement and on with my girlfriends. I am trying to make it to where my balance shows on hers and her balance shows up on mine. Is there anyway to do this.
Get married then YOU won't have a balance to worry about<g>
Open both workbooks then Window>New Window>Arrange>Vertical.
You should have both workbooks side by side in the window.
In a cell on your workbook(sheet) where you want her balance placed enter an
equal(=) sign.
Select her workbook(sheet) balance cell and hit <ENTER>.
Do same other way around.
Cells and workbooks are are now linked.
Save both workbooks.
Gord Dibben Excel MVP
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.
