separate workbook

  1. A

    Open, Copy data and Close a workbook based on the names of the tabs in my active workbook

    Hello everyone, Apologies English is not my first language and I am very new to writing VBA codes. So far, I have only copied and adapted parts of the codes to fit my needs. Recently, I have created a workbook, each tab has the name of a treatment site. Daily, I receive data about these...
  2. W

    move a row to another sheet and separate workbook based on cell value with button

    I discovered another thread close to something I am trying to do. Automatically move a row to another sheet based on cell value I am trying to do pretty much the same thing but with a button and with the copied data from columns A-M only going to 3 places at once, another sheet in the same...
  3. B

    VBA code rather than vlookup

    I have a worksheet that I am using vlookup to return values from a table (in the same workbook) based on a value I select in a drop down box in the worksheet...I want to change this up to use VBA and have the tables in a separate workbook. So essentially... I select a dropdown box value from a...
  4. J

    Replacing values in cell in one workbook with another workbook

    Okay this one is a little tricky and i have been trying to play around with it but can't seem to get it to work correct. I have one workbook that i need to replace the cell values with another workbook. example Cell B3 on workbook A needs to look up on workbook B Column B and once found...

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