Question Locked

Excel Copy Cell Help

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I keep a register (like in a check book) on excel on my home PC because it is really convenient when doing online banking. I have a worksheet for both my checking accounts, a few other assets i like to keep track of, and i have a budget sheet. I use formulas everywhere to do the math for me and I would like to reference the ending balance of my two checking accounts to my budget worksheet. I have tried =vlookup and i have tried =Mainaccout!D112 and both return a value of $0 no matter what the total is. I have even tried referencing a cell that does not have a formula within it and get the same value. Help?

Microsoft Win XP SP 3
Microsoft Excel 2002

4 replies

by Former member

Clarifications

by thumbsup2

Are you using one spreadsheet with multiple tabs (sheets), one for each account? Is Mainaccount one of the tabs you see along the bottom? Is it spelled exactly like that, capitalization and all?

When you tried using =Mainaccount!D112, did you just type that into the cell, or did you press the equal sign and then navigate to the correct sheet and click cell D112, then press enter?

Did you format the cell on your budget sheet where this formula sits so that it's set to financial?

by Former member

Actually I figured it out. I was going back to the page with the reference so that the address ended up Budget!c12 or whatever. Not sure why i did not catch it before, but thanks for the help anyways.

by airle

Use SUMIF or google free check register spreadsheets

Example of SUMIF is here, but this was just designed for private use. Sorry but esnips requires download to download their files.

http://www.esnips.com/web/airlesswishsStuff

If you download esnips, be sure to choose Advanced install to de-select automatic changes to your web browser home page, etc.

This discussion is closed to new replies.