linking workbooks

I have 2 workbooks; QuoteWorkbook which there will be thousands of copies, and a MasterWorkbook which will hold an inventory of prices for the QuoteWorkbook to reference. MasterWorkbook has multiple copies of PricingWorksheets for QuoteWorkbook to reference one of. The goal is to be able to...

So I've linked two separate workbooks, let's call them each work book: WB-A and WB-B and they are each contained within one folder. "WB-A" feeds "WB-B" which does a calculation based on the inputs in "WB-A". Then "WB-B" outputs it's calculations back into "WB-A". I've simply linked the cells...

Can anyone tell me why this line of code is not working: ActiveCell.FormulaR1C1 = "=IF(RC[-5]>0,VLOOKUP(RC[-5],'C:\Users\Scott A. Schmeling\Google Drive\HCA Files\Projection Files\Projection Spreadsheets\Org 5110 Projections.xlsx'!Table2[#All],3),"")" I keep getting an application defined...

Hi there, I'm looking for a way to count a certain amount of my workbooks that have a certain value. i.e. I have a quoting system with excel, which I am wanting to add in a checkbox for the Employee to tick once the quote has been accepted. My intention is for a separate workbook to have a...

Is it possible to link cells to a folder and have it select the most recent workbook to get the data from? All the workbooks in the folder have the date in the title.

On my PC I have no problem starting Excel, opening two files that are linked and seeing the destination file change instantly when I update the source file. However, if instead I start two Excel applications and open only one file in each the link does not work. For instance If I add a test...

I am using excel 2007 to create a series of linked workbooks in excel 97-2003 format on sharepoint. I have one source file that links to 32 destination files. The source file contains multiple tabs. All values are text. I am copying a cell range and using the paste link function in the...

Hi guys I have a though question and my search hasn't paid anything off, so this is my last resort let's say. I have 2 excel files. Excel A : excel file from our supplier Excel B : excel file containing our products we sell The point is having values where our purchase price from our...

Hi, I have two excel workbooks, one created in excel 2003 and the other using excel 2007. When i link a cell from the excel 2007 workbook to a cell in excel 2003 workbook (that has some text in it), it shows a "#N/A" message. However if i then open the excel 2003 workbook using excel 2007...

<HR style="COLOR: #ffffff; BACKGROUND-COLOR: #ffffff" SIZE=1> <!-- / icon and title --><!-- message --> I am trying to link 2 excel Workbooks together and I am wondering if using the SUMIF Function is the best way to do this. I will try to explain and illustrate my position. First I have a...

I really don't know if this is even possible in excel but will try to explain what I am trying to do and if it is possible this will save a lot of time!! I have a master workbook with client number as column heading and various other headings across the worksheet. Down the column for client...