About 50 results
Open links in new tab
  1. Duplicate Page 1 on Page 2 - Same Worksheet - MrExcel

    Jul 10, 2012 · Greetings, I've created a form on page 1 of Sheet 1 and I'm having trouble cutting and pasting that to page 2, page 3, etc. (same Sheet). The row heights don't follow the pasted …

  2. Solved: Moving or Copying Worksheets changes theme colour

    Jan 9, 2013 · I have done some troubleshooting with colour change when moving/copying sheets to new workbooks that hasn't been documented very well online, for which a solution is yet to …

  3. How to copy page breaks from one worksheet into another?

    Apr 14, 2014 · I’m using a macro that consolidates excel worksheets from different workbooks into one workbook. But how/what is the code is to copy the pagebreaks in each worksheet onto the …

  4. VBA code which copy data from a web page in excel

    Aug 20, 2014 · First of all, I need the code to open each match in a separate window and to copy a table from that page, and then to paste it in Excel. Secondly, if I repeat the action after 8hrs, …

  5. VBA Copy Internet Explorer webpage and paste into Excel using …

    Dec 14, 2011 · I have a code that opens various web pages, copies (Select-All) the information on the web page and then pastes the information into an excel using match destination formatting …

  6. [VBA] Copy Range from Excel Paste into Word Autofit Contents to …

    May 16, 2018 · I'm trying to copy a range from an excel worksheet to word but when I do, it changes the text formatting and the table extends beyond the first page (both to the right and …

  7. VBA How to copy page/print settings when copying worksheet

    Nov 14, 2011 · I have developed a macro that copies worksheets from one workbook to another. In the original workbook, the page and print settings are correct. When copied to the new …

  8. Is there a way to copy and paste slicers from one worksheet

    Dec 19, 2022 · The slicers in the original worksheet still filter the data from the charts that were pasted into the new worksheet, but I would like to have them in this new worksheet. I know …

  9. Copy page setup (including page breaks) - MrExcel

    Oct 17, 2009 · Hi There, Can anyone help? I need to copy a series of worksheets from a source workbook to another workbook using VBA. The problem is that the copied worksheets need to …

  10. Make an 'dynamic' copy (link) of a table to another sheet

    Apr 9, 2010 · Hi all, I have a simple yet complicated question. I made a very big table/database on the first tab of an excel sheet. This database is full of formulas etc. and not prety, nor handy to …