any IT experts here, help

al n sal

Guest
Hi guys
sorry but not a wilding question, I'm hoping someone can help me here. I'm trying to put a spread sheet together for work and this is really really doing my box in:pc:....

I need to copy a sub total from the bottom of a sums column on one sheet and paste it to another sheet......does anyone know how to do this...on vista excel

please help me
 
On the sheet where you need the result, click on the cell enter the = sign then without doing anything, go to the page with the SUM in, double click on that cell

Go back to first cell and it should now be there, in the top line it will say =sheet ref cell no
 
Yes

But the post above saved me typing it :)

Only thing I'll mention, is if it is a different work book (document) rather than work sheet (tab) then it may not go to plan.
 
thanks guys, but i'm getting (=summary!E1000) and no figures....
I'm hoping to track the running total onto another sheet in the same work book. i'm doing something wrong but can't figure it.........
 
Okay, copy the cell with the cell with the subtotal, go to the next sheet, and single click on the cell you want to copy the value into, go to Edit > Paste special > Values.

The only problem with this is that it won't update when the subtotal in the first sheet changes.
 
Okay, I've remembered how to do it now!

Lets say that the sheet with the subtotal is Sheet1

Lets say that the cell with the subtotal is A12

In the cell of the second sheet you type =Sheet1!A12 (the ! is important!)

This will automatically update the value in the second sheet if the value in Sheet1 changes.
 
is there a way of uploading a workbook onto here, as i still cant gt it to work, comes up error
 
Have you followed my last post exactly? It's important to get the syntax right. I've checked it and it works fine for me with Excel!
 
I've done the formulas, so all you have to do is use the same format to put the total where you want them using my formulas as a guide.

I think there was a misspelling of the Cash Sales label on that sheet in the tab at the bottom, because it wouldn't recognise that name (perhaps an extra space at the end?), but when I renamed it to Cash Sales, it worked fine.
 
Last edited:
showing value on another spreadsheat (tab)

Copy the cell required. Go to the other tab and go paste special into the required cell then click paste link (down bottom left). The value you put in the first cell will then always appear in the second cell.

regards,
Bob
Brisbane Aust.
(touring Uk June-Aug 2012)
 
Perhaps it would help people to know which version of excel you are using. :help:

I don't use excel very often but I imagine there would be differences in the way things work from year to year??
 
Thank you so much to everyone who posted and tried to help me sink it into my little old brain, but in the end i was able to send it to Angela and Richard who played with it and sent it back working:idea-007: with some advice,

so I've been playing with it since i finished at lunch time and .....Yayyyyy:banana: i finally figured out how it works...:rockroll::rockroll: thank you you saved me beating my head to a pulp:hammer:, I owe you guys a drink when we meet up.

thanks

al
 
You must log in or register to reply here.

Users who viewed this discussion (Total:0)

Back
Top