The 1947 - Present Chevrolet & GMC Truck Message Board Network







Register or Log In To remove these advertisements.

Go Back   The 1947 - Present Chevrolet & GMC Truck Message Board Network > Welcome and Discussion > General Discussion

Web 67-72chevytrucks.com


 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 09-15-2008, 12:24 PM   #1
glock35ipsc
Next project: 1970 K10
 
glock35ipsc's Avatar
 
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
glock35ipsc is offline   Reply With Quote
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 02:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Copyright 1997-2025 67-72chevytrucks.com