2 workbooks

  1. A

    VBA Vlookup function returns wrong values

    Hi I am using vlookup function in VBA codes to import data from one excel file to another. The source file opens successfully. The code runs with no error messages. But the imported value are not correct. The expected values imported are attendance percentages from the source file. However...
  2. R

    macro button action, copy info from another workbook, and display in anotherworkbooks merged cells

    I have 2 workbooks, Book1 and Book2. on Book2 I'd like to click a button that will copy info from Book1 and paste it ito Book2's "Cover" sheet. In Book1: the info that I want is in column E. This info is 0 to 20 five digit numbers (concatenated from an earlier action), all separated by at least...
    • Raceman
    • Thread
    • 2 workbooks common value concatenate copy and paste macro
    • Replies: 0
    • Forum: Excel Questions
  3. P

    Transfering data from one workbook to another automatically

    Here is what I am trying to do, If I have a document named Test.xls on my G:\ Drive and on my masterlog, that is also on the G:\ Drive, I have the name of that document listed in A1(Test) I would like to have a formula that would say IF(G:\folder**** = A1 then populate B2 from Test.xls in...
  4. A

    Vlook up and DV over 2 workbooks

    this is my first attempt at anything like this, i am wanting to link two workbooks together with the aim that when a option is selected in a drop down menu in workbook "band form", it auto populates the rest of the form with data from the second workbook "showsales2013". date, ticket price...

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