link between workbooks

I am in charge of metrics for my company and we gather a lot of different information from different sources. Currently I have created a workbook that has 5 different data worksheets and 7 worksheets that calculates and displays the information. I am trying to create a Client Template where I...

So what I am tring to do is to get results (a number) from a cell which is a result of a formula. This is in a workbook that is not open but in the same network drive and folder as active workbook. I have searched past posts and have had no luck. This is the formula I have tried...

I've read over these threads for quite a few years now and have almost always found any answers I needed, or at least got pointed in the right direction. Unfortunately, I need to ask for your expertise. I am using Excel 2007. I put together an Estimate sheet that pulls date from a Master sheet...

I have no problem linking one workbook to another, but I have a workbook residing in a folder in SharePoint and access to the folder is restricted. I want to create a workbook in another unrestricted folder that is linked to the original, so others can still view the contents of the workbook. •...

Here's my situation: I have a master workbook file that has links to a feeder workbook. Master file and feeders are in the same folder. As I have developed this file I have kept it local on my computer. Locally, when I update one of the feeder worksheets, the master sheet is updated...

I am trying to use vlookup for a different workbook, but the file name of the workbook changes daily (it's updated everyday). The format of the file's name is consistent, and only changes according to the date, so today's file name would be "file_02132014.xls" So far what I have that works is...

Ok, so this is something which is probably so simple but I can't figure it out. I need a macro to create a linked cell to another workbook. The name of the workbook will change every time. The other workbook gets assigned a name based on a value they type into a form at the beginning, which is...

Hi So I have two excel sheets, one which contains a database (named Price References) and the other one which has the search function (Named Search). However, I would like to have the database in a separate workbook and like the search sheet to exist in a different workbook. Now the problem...

Does anyone know if it is possible to link into a cell the sum of a line of figures? I was trying to press an "=" into the cell that I want the answer in, and then highlight the row I need the sum of (which is on a different sheet) It is returning with a 0 value every time, even though there are...

<tbody> Run ID Carrier ID % LIVE Cut Time LOADING/DONE Trailer # Bills Cut </tbody> Above is the information that is contained in each work book. I need to create a Macro that will allow me to search up to 7 days of these files. Each day of operation is saved to a new file. I need to be...