Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I am going on about 5 hrs sleep in the last 48 hrs so bare with me.....
I know this is easy but i cant think.... I am trying to add 2 different cells from one workbook to 1 cell in another workbook linked.... Someone make me realize that i need to give up and get some sleep..... ='[client book placements recovery301.xls]Sheet1'!$G$720 ='[client book placements recovery301.xls]Sheet1'!$G$776 Those are the 2 cells that i am trying to add via a link to another page as you can see. Thanks... Send Starbucks my WAY |
#2
![]() |
|||
|
|||
![]()
Just add a plus sign inbetween each reference:
='[client book placements recovery301.xls]Sheet1'!$G$720 + '[client book placements recovery301.xls]Sheet1'!$G$776 --- Regards, db "chisigs2" wrote: I am going on about 5 hrs sleep in the last 48 hrs so bare with me..... I know this is easy but i cant think.... I am trying to add 2 different cells from one workbook to 1 cell in another workbook linked.... Someone make me realize that i need to give up and get some sleep..... ='[client book placements recovery301.xls]Sheet1'!$G$720 ='[client book placements recovery301.xls]Sheet1'!$G$776 Those are the 2 cells that i am trying to add via a link to another page as you can see. Thanks... Send Starbucks my WAY |
#3
![]() |
|||
|
|||
![]()
Thanks..... that works great..... The IDIOTS on MREXCEL.COM couldnt
come up with that... Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
is there an easy way to move parts of cells around | Excel Discussion (Misc queries) |