copy sheets to workbooks

  1. M

    Copy Macro doesn't copy data validation

    I have a macro that I'm using to copy two sheets from one work book to another workbook. The copy works - what doesn't work is copying the data validation that I have on one of the sheets where it has a drop down list based on the other sheet? Any suggestions to make this also copy along with...
  2. H

    Copy part of sheets to new workbook

    Hi all, Tried to find a solution for this but it seems I'll be the first to attempt it. I have a workbook containing several sheets, there are 7 permanent sheets that I have renamed as Sheet01 to Sheet07 and a growing number of other sheets. A macro allows the users to create a new set...
  3. J

    Check and Copy sheets from one wb to another

    hello - I have been working on how to check and copy (would love to merge or sync) sheets from one workbook to another. The reason is that I have to input data on a PC that is stripped and/or blocked from running macros, then work on the data in a different office that allows macros. So I have...
  4. S

    Copying Active Sheet stops abruptly after execution without throwing any error!

    Hello All, I am trying to copy a sheet called Temp in a workbook and pasting in the same workbook multiple times. For oj = 2 To 21 Application.StatusBar = "Please wait... PBA's are generating" If ActiveWorkbook.Sheets("Temp").Visible = True Then...
  5. U

    One sheet from one workbook to another workbook

    Oh please help I have 12 workbooks that are used by different people in different offices that all report to the same manager and that manager wants to be able to open up one workbook to see all the summary sheets from each of the 12 workbooks. And I'm having issues getting the codes posted for...
  6. P

    Help with macro for copying sheet to existing workbook

    Hi all I'm trying to copy one sheet and insert it to another existing workbook (storing it for future reference)..... It will copy the sheet but it also copies over the other sheets already in the workbook..........I have no idea what I've done wrong I'm using Excel 2010 on Windows7 here's the...
  7. M

    Help!

    Hi I will start by saying i am not at all good with macros but have been asked to put a button on a excel sheet that will open every other workbook in the same folder and copy the sheets individually to separate workbooks and name the workbook the same as the sheet it came from. Suffice as to...

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