linking workbooks

  1. D

    Formula for linked workbooks that toggles different worksheet names to reference versions of prices

    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...
  2. L

    Linking Excel Workbooks, #REF problem

    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...
  3. S

    VBA Lookup Help

    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...
  4. Y

    Linking Checkboxes to another workbook

    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...
  5. T

    Link cells to a folder to find most recent data

    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.
  6. R

    Linking Workbooks on different Excel Apps, same PC?

    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...
  7. M

    linking multiple workbooks: #n/a error

    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...
  8. V

    Linking variable values between 2 excel files

    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...
  9. A

    Link problems excel 2007 to excel 2003

    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...
  10. S

    Link 2 excel Workbooks together with SUMIF Function

    <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...
  11. K

    Complicated cross referencing excel workbooks and files question!

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top