IT geeks help please

Closed Thread

Old Mar 29th 2014, 7:35 am
  #1  
Lost in BE Cyberspace
Thread Starter
 
kittycat1's Avatar
 
Joined: May 2009
Location: Dubai
Posts: 5,965
kittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond repute
Default IT geeks help please

Hi Geeks,

So computers are absolutely not my strong point- in fct the polar opposite is about right. I am working in excel and need to make certain numbers from different pages magically appear on the last page and sum up. I have absolutely zero idea on how to do this. Can anyone help me please.



Thanks in advance

KC
kittycat1 is offline  
Old Mar 29th 2014, 7:45 am
  #2  
Knee deep and rising
 
weasel decentral's Avatar
 
Joined: Sep 2011
Posts: 2,754
weasel decentral has a reputation beyond reputeweasel decentral has a reputation beyond reputeweasel decentral has a reputation beyond reputeweasel decentral has a reputation beyond reputeweasel decentral has a reputation beyond reputeweasel decentral has a reputation beyond reputeweasel decentral has a reputation beyond reputeweasel decentral has a reputation beyond reputeweasel decentral has a reputation beyond reputeweasel decentral has a reputation beyond reputeweasel decentral has a reputation beyond repute
Default Re: IT geeks help please

If there is not too many numbers, just copy them from the first page and paste them on the last page. But as you paste you might see some options for it, so chose paste link (it's an icon like a chain)
This means if you change the number on the first page it will automatically change on the last page.
There are more complicated ways to do it also.
weasel decentral is offline  
Old Mar 29th 2014, 7:49 am
  #3  
Lost in BE Cyberspace
Thread Starter
 
kittycat1's Avatar
 
Joined: May 2009
Location: Dubai
Posts: 5,965
kittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond repute
Default Re: IT geeks help please

really? thats it? so simple?

Thanks Weasal

will try it now.
kittycat1 is offline  
Old Mar 29th 2014, 9:22 am
  #4  
Hit 16's
 
Bahtatboy's Avatar
 
Joined: Mar 2010
Location: Of all the gin joints, in all the towns, in all the world, she walks into mine
Posts: 13,118
Bahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond repute
Default Re: IT geeks help please

Another way: go to the cell in the last page (I guess you mean tab) where you want the number to appear, press "=", then carefully (i.e. without selecting any other cell), move to the tab which has the source data, and simply click in the cell with the source data and press "return" (or "enter").

If you want the cell in your last page to be a sum of numbers on another tab, start as above (i.e. go to the cell in your last page where you want the sum to appear) but this time click "Ʃ", then go to the tab with the source data and carefully select those cells which you want to add up (they must be adjacent to use "Ʃ").

Hope that helps
Bahtatboy is offline  
Old Mar 29th 2014, 9:37 am
  #5  
Down and out
 
ctfc's Avatar
 
Joined: Jul 2008
Location: Re-Expated
Posts: 868
ctfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond repute
Default Re: IT geeks help please

Just type in some random numbers.

Given that you're asking this question, it's highly unlikely the rest of your spreadsheet works properly anyway
ctfc is offline  
Old Mar 29th 2014, 9:40 am
  #6  
Hit 16's
 
Bahtatboy's Avatar
 
Joined: Mar 2010
Location: Of all the gin joints, in all the towns, in all the world, she walks into mine
Posts: 13,118
Bahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond reputeBahtatboy has a reputation beyond repute
Default Re: IT geeks help please

Originally Posted by ctfc View Post
Just type in some random numbers.

Given that you're asking this question, it's highly unlikely the rest of your spreadsheet works properly anyway
Strangle him with some dental-floss knickers, Kittycat.
Bahtatboy is offline  
Old Mar 29th 2014, 10:44 am
  #7  
Lost in BE Cyberspace
Thread Starter
 
kittycat1's Avatar
 
Joined: May 2009
Location: Dubai
Posts: 5,965
kittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond reputekittycat1 has a reputation beyond repute
Default Re: IT geeks help please

CTFC-

You may well be right to be fair

But I have made it colour coordinated
kittycat1 is offline  
Old Mar 29th 2014, 9:41 pm
  #8  
Down and out
 
ctfc's Avatar
 
Joined: Jul 2008
Location: Re-Expated
Posts: 868
ctfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond reputectfc has a reputation beyond repute
Default Re: IT geeks help please

Originally Posted by Bahtatboy View Post
Strangle him with some dental-floss knickers, Kittycat.
Don't you normally have to pay extra for that kind of fun?
ctfc is offline  

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


Contact Us Archive Advertising Cookie Policy Privacy Statement Terms of Service