multi workbooks

  1. P

    Type Mismatch when defining workbooks

    Hello! I am probably doing something wrong but I keep getting an error and I dont know how to fix it. The long and the short of it is I have to copy data between three different excel workbooks Dim wb1 As Workbook Dim wb2 As Workbook Dim wb3 As Workbook ' Set wb1 = ActiveWorkbook Set wb2 =...
  2. C

    return specific data without spaces

    Hi, I have a spreadsheet like the below, that has a long list of clients from sales agents and their current status. ie confirmed pending lost. This spreadsheet is updated constantly with status new deals and amounts. I want a spreadsheet for each Sales Rep that references this master sheet...
  3. J

    Copy active worksheets

    Hi I have a workbook that I use for inventory tracking. I make a copy of the last worksheet almost every day and name it todays date. After some time the workbook becomes very large and slow to work with. I am therefore trying to create a macro that will move all previous months sheets to a new...
  4. Q

    Multitabbed list and v lookup

    I have about 14 different tabs, all named after their specific group. In each of those tabs, there is a list of people and about 14 different columns with data regarding each of them. I am trying to have a main cover page with a dropdown to chose a specific person and then have the neighboring...
  5. T

    Checkboxs linked

    I have two workbooks (1 and 2) used as a Data gathering report builder and datadase on both sides. On each there is a Checkbox (A and B) (Active X) that is used for the same purpose (to back-date the schedule after midnight [12.00am] and then update the schedule each day after the production has...

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