seperate workbook

  1. A

    Indirect function, to link changing tab name from seperate file

    Hi there, I'm looking for a formula to link back a tab from separate file (file stays the same) but the tab name will be the changing parameter set on what is in cell A1. So for instance: In a file "Z" cell A1=YOY (that's my tab name) Therefore, I would like to link what's in a cell D1 of...
  2. C

    VBA to consolidate data from selected multiple worksheets in a different workbook

    Hi, I have 2 files. One file is the source of data and the other file is for extraction of the data and analysis. In the first file, I have many worksheets, but I would like to consolidate the data from worksheets, which contains "production" in the worksheet name. The destination of the...
    • cloclo
    • Thread
    • consolidate merge multiple workksheets seperate workbook
    • Replies: 1
    • Forum: Excel Questions
  3. S

    Is it possible to print linked workbooks on separate printers at the same time excel 2007?

    Here is the scenario, hopefully you boffins can help We have two printers in the office. Printer 1 = Card and Printer 2 = Paper.... With each customer order we have to print a sales order workbook for our production dept, which has to be printed on card. We also have to print a quality...
  4. C

    Index/Match from one work book to another.

    Hello All, I'm trying to use INDEX/MATCH to pull data from one workbook, managed by a seperate department, to a workbook my department uses to track progress during different product launch phases. I thought about using VLOOKUP but I can't garuantee that the other departments workbooks will...
    • charlsand
    • Thread
    • contains a constant index match seperate workbook value not available
    • Replies: 0
    • Forum: Excel Questions

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