My Account
Sign up, and you'll be able to vote in polls.
Sign up
Report problem with this ad
Start a related thread
Start a related poll
Reply via Boardmail
Mar 15, 2017
4:22
:58
pm
fattycoug
All-American
Excel Q: how do I take a number from one sheet and place it into another
automatically? It's not a sum because it's already a sum. I just need the sum to go to another table so I can see each month easier and have a sum for the entire year.
If that even makes any sense
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
fattycoug
Bio page
fattycoug
Joined
Sep 9, 2002
Last login
Apr 25, 2024
Total posts
69,473 (11,075 FO)
Report problem with this ad
Messages
Author
Time
Excel Q: how do I take a number from one sheet and place it into another
fattycoug
3/15/17 4:22pm
Link?
foofcoug
3/15/17 4:23pm
In the cell where you want that number, type "=" then point to the cell in the other table
tisdaplace
3/15/17 4:27pm
sweet. anyway to do an entire row?
fattycoug
3/15/17 4:38pm
Sure. Just copy and paste that first destination cell to the entire row.
tisdaplace
3/15/17 4:43pm
=NameOfOtherSheet!C3
spoxjox
3/15/17 4:35pm
crtl+c "copy" and paste special as a link in the destination cell.
CougsOrDeath
3/15/17 5:36pm
Report problem with this ad
Posting on CougarBoard
In order to post, you will need to either
sign up
or
log in
.
Report problem with this ad