I am newbe to discussion group but my solution would be: 1) to click on cell that you want total or value of cell of another workbook 2)type = sign and then select other work book, sheet, and cell that you want. 3) the resulting formula in that cell would be something like this: ='[junk2.xls]Sheet1'!$C$2
You could actually have a cell that might total two different cells in two entirely different workbooks, eg: ='[junk2.xls]Sheet1'!$C$2+[junk3.xls]Sheet1!$A$1 This would not show the directory that the file is saved because all three of the files are saved in the same directory. If files are in different directories, it will actually show the directories. Hope this is helpful!! T Dejong On Feb 18, 2:19 am, "Chidurala, Shrinivas " <shrinivas.chidur...@citi.com> wrote: > Dear All, > > I have cash entries in one workbook and I want total of some specific entries > in different workbook. > > Please can you help me on the same. > > Regards, > Shrinivas > > FA.xls > 18KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel