workbook linking

  1. S

    Linking to a workbook that doesn't yet exist - for use in template creating

    Hi all, I am trying to link separate workbooks-not-worksheets that are yet to be created - these would be workbooks created in the future using templates, and the destination workbook I am working in will be a master template as well. This is for a project for study and I have really hit a...
    • SophieYaldwyn
    • Thread
    • linking linking to a workbook that doesn't linking to future workbooks syntax error syntax errors syntax of the name workbook linking
    • Replies: 11
    • Forum: Excel Questions
  2. D

    Accessing a Workbook in use by another application

    Im currently writing a vba program to do with gambling. The problem i have is connecting to a workbook that is in use by another application. Im using a program called "Bet Angel" which links to an excell workbook and continuely updates odds. I then have another workbook which is my data sets...
  3. D

    How to hyperlink and auto-filter

    Hi, I am trying to set up a document portal for a rigging spreadsheet onboard a large vessel. I need to create hyperlink buttons that will open a new page titled - Equipment List and depending on which button you push from the front page (e.g Wire Rope Grommet, or System Sling) only the named...
  4. R

    Sorting Data in a Linked Workbook

    Hi; I am having some problems and would really appreciate any help I have column A of workbook B linking to data in column A of workbook A; then column B of workbook B has independent data values. When I sort column A of workbook A the data points move in workbook B; and then columns A and B...
    • renato1
    • Thread
    • link between worksheets link fields sort workbook workbook linking
    • Replies: 1
    • Forum: Excel Questions
  5. S

    Dynamic reference to another workbook

    Hi, I am registering data in a weekly workbook (A) and treating these data in another weekly workbook (B). In this process I would like the workbook name in the formula for retrieving data in workbook (B) to update automatically with week number from an input cell. Specifically I have the...
  6. R

    Using the equal sign or plus sign does not link cells in separate worksheets anymore

    I have two files, A and B. I used to be able to select a cell in File A, type = or +, and then click on a cell in File B, which would populate/link the cell in File A. Now nothing happens. Any suggestions would be greatly appreciated. Thanks!
    • Roinda22
    • Thread
    • cell linking equal sign plus sign workbook linking
    • Replies: 3
    • Forum: Excel Questions
  7. J

    Printing into another workbook.

    Hi, I have a feeling this may be out there somewhere, but after extensive searching, I can't find it. I want to use VBA to print cells into another workbook in the same way that you can print into another sheet in the same workbook using code similar to this: (For example if I wanted to print...
  8. M

    Macro to another workbook

    Hello, I'm trying to write a macro that grabs information from another workbook. How would I write the link to this workbook? My guess was something like this but it's not right: Workbook("workbookname").Worksheets("sheetname").Range("K3:AC79") Thanks in advance for any answers

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
Back
Top