Release List Reviews Shop Join News DVD Giveaways Video Games Advertise
DVD Reviews | Theatrical Reviews | Adult DVD Reviews | Video Game Reviews | Price Search Buy Stuff Here
DVD Talk
DVD Reviews DVD Talk Headlines HD Reviews


Add to My Yahoo! - RSS 2.0 - RSS 2.0 - DVD Talk Podcast RSS -


Go Back   DVD Talk Forum > General Discussions > Tech Talk

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Reply
 
Thread Tools
Old 08-10-04, 03:25 PM   #1
Canis Firebrand
Video Game Talk Reviewer
 
Canis Firebrand's Avatar
 
Join Date: Dec 1999
Location: Formerly known as "Vryce"/Detroit, Michigan
Posts: 13,504
I hate excel xp. Need help

Okay.. I'm using excel to setup a budget and am having an extremely frustrating time.

I have a worksheet that I set up to hold all my values.
On another worksheet, that is the actual budget, I have each month as its own column.

I use a formula to copy the value from one worksheet to another.
When I use copy and paste across the months, it increments the cell it grabs the value from.

I just want to copy and paste the exact same cell reference as its the same for every month.
I want to do it that way so that if any numbers change, I just have to change it in one spot instead of in every month column.

Thanks for any help.
__________________
XBox GamerTag - Canis Firebrand - add me if you like. My 360's Blog
PS3 ID/Steam/GameCenter: CanisFirebrand | My Wii Code: 0288 0678 9931 3944
8-Bit Brigade | VGT Review Page | Twitter | Books | Board Games | Boardgame Wishlist
  Reply With Quote
Old 08-10-04, 04:53 PM   #2
cseyer
DVD Talk Special Edition
 
Join Date: Aug 2003
Location: Bloomington, IN
Posts: 1,025
This can easily be fixed by using a $ sign in front of the column/row reference you want to remain fixed. For example =Sheet2!A2 would copy Cell A2 from Sheet 2. Now if you copy and paste that formula to the next cell to the right it will make it =Sheet2!B2. Now if you start with =Sheet2!$A2 and paste to the right you will get =Sheet2!$A2 in each cell. If you paste down one cell you will get =Sheet2!$A3. To fix both the column and the row simply put a $ in front of the reference ie =Sheet2!$A$2 and it will not increment/decrement (is that a word) at all.


And if that confuses you try searching help for absolute vs. relative cell references. The built in help is good.
__________________
My DVD's

Last edited by cseyer; 08-10-04 at 04:57 PM.
  Reply With Quote
Old 08-10-04, 06:43 PM   #3
Canis Firebrand
Video Game Talk Reviewer
 
Canis Firebrand's Avatar
 
Join Date: Dec 1999
Location: Formerly known as "Vryce"/Detroit, Michigan
Posts: 13,504
Thank you.. That certainly should help. I'll give it a try.
I looked up in the help, but wasn't sure what terms to use. I got some information about copying cells, but not the answer I needed.

Thanks again!
__________________
XBox GamerTag - Canis Firebrand - add me if you like. My 360's Blog
PS3 ID/Steam/GameCenter: CanisFirebrand | My Wii Code: 0288 0678 9931 3944
8-Bit Brigade | VGT Review Page | Twitter | Books | Board Games | Boardgame Wishlist
  Reply With Quote
Old 08-11-04, 07:20 PM   #4
OldDude
DVD Talk Legend
 
Join Date: Jul 2001
Location: MI
Posts: 24,713
When you are entering formula, the F4 function key will toggle through the 4 possibilities of $ or not on row and column. I don't know if that is easier or harder than typing the $ where required, but it is another way. If you are editting a formula, you can put cursor on a variable (between row and column ref.) and press F4 to toggle.

Relative vs absolute addressing is a PITA and easy to make a mistake. Good news is that its pretty easy to edit.
__________________
9/11/2001 - You have awakened a sleeping giant, and filled him with a terrible resolve. - paraphrased from Yamamoto
  Reply With Quote
Reply

Thread Tools

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 On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


All times are GMT -5. The time now is 11:16 PM.

Rules - DVD Talk - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.2.0
Copyright 2011 DVDTalk.com All Rights Reserved. Privacy Policy and Terms of Use.