1. L

    Make a more complex VLOOKUP formula

    Hi, I have twoexcel documents, "Book1" and "Book2". Book1 is exportedfrom our business system. Book2 is a compilation of forecast from the businesssystem data that were exported. Today Ihave to manually put in the data from Book1 to Book2. I want to automate thatprocess. In Book2 Ihave...
  2. M

    Extracting data from an other workbook using formula and a refering cell

    Hi all I've been looking on this forum, but can’t seem to find exactly what i'mlooking for... So, my question: Say you have a number of workbooks: Book1, Book2, Bookxx and Overview I need to extract data from Book1 and Book2 (and the others) into Overview. Now, I know a formula for Overview...
  3. K

    Referencing a cell in another worksheet.

    Hello I have a question. I have a worksheet in a workbook called "book2". In the worksheet "book2" the cell D14 takes the sum of those numbers above it and displays the sum in cell D14. My question is if I want to reference the of cell D14 in the worksheet "Book1" how would I do that? Thank...
  4. 1

    replace data from sheet

    Hi Everyone - I use this often to replace data on my sheet: <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">Private Sub Update_EstDelv1() Dim lr As Long, I As Long Dim x As Variant lr = Range("A1").End(xlDown).Row For I = 1 To lr x =...
  5. W

    Matching different Columns to get data.

    I need some help, i have been scouring for an answer on this one and i have hit a wall. Here is my question, buckle up and hopes i can explain it right. I have 2 work books. One contains job titles that come from a database in its own format - Call it book1. The second workbook has my master...
  6. J

    "Book2" created with linked cells. Now can't find Book2 file

    I was in an Excel document and opened the same document in the screen (reduced the screen and added a second window in the document). Basically opened the document showing a different tab in the document. I changed a cell in the newly opened document tab and apparently saved the new document...
  7. Dougie1

    On Opening Workbook – Import Data and Refresh Pivots With The Imported Data

    Hi all, After some help if possible? Am using Excel 2016 I have 2 Excel workbooks saved in the same SharePoint folder (Book1 & Book2). Book1 contains a data set on Sheet1 (cols A to P) - the most up to date version of the data. This will be a fresh export that has been saved to the...
  8. P

    Applying filters accross Multiple Workbooks

    Hi all, I am sadly using office 2010 I have two SEPRATE workbooks (Book1 and Book2) Both workbooks have a similar filter for postcode(zip code for the USA) I want to select a Postcode within book 1's filter and have that also apply to the filter within book2. Any ideas? Thanks JC

Some videos you may like

This Week's Hot Topics

  • Use Filter function with 2 criteria to return a specific value
    I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
  • Loop stopping at row 10
    Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
  • Numerical Order Code for Macro
    I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
  • Calculate time in excel
    I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
  • VBA
    Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
  • Help with formula to sum numbers prior to date
    Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

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