![]() |
![]() |
#1 |
Next project: 1970 K10
Join Date: Feb 2004
Location: Fort Collins, Colo 80524
Posts: 6,684
|
MS Excel help
I am having trouble with a formula to reference a cell in another worksheet on the same file.
I have a budget done in Excel, with each worksheet being one month. The worksheets (I'll call them tabs for short) are labeled like 2008 Budget, Septemberand so on. I another spreadsheet I have set up for monthly purchase order tracking, I have one tab that lists the total of the PO's for each month. For that, I use a formula to pull the numbers from one cell in each tab, than another to add all those for a running YTD total. The formula I use to pull from the one cell in each tab goes something like =September!J71 . Don't know if this is correct or not, but it works. When I try to use the same formula on the budget, it does not work. Do I need to do away with the spacing between the words, drop the word BUDGET and make it something like September 2008, or does it all need to be one word like September2008? I'm not an Excel wizard, so I'm stumped as to why the formula works on one spreadsheet but not another for the same purpose. Thanks in advance!
__________________
Bob 1970 Chevy K10 LWB "Goldie" 350/TH350 next project!! 1981 Chevy C10 LWB 355/TH350 - My son's truck LS SWAP FORUM! Tons of LS swap info here! PLEASE CLICK HERE TO SUPPORT THE GREATEST BOARD ON THE NET! CLICK HERE FOR THE FAQ INDEX by KRUE |
![]() |
![]() |
Bookmarks |
Thread Tools | |
Display Modes | |
|
|