+ Reply to Thread
Results 1 to 3 of 3

Using Combine macro to combine multiple worksheets - need to modify to paste formulas

  1. #1
    Registered User
    Join Date
    05-18-2012
    Location
    North Carolilna
    MS-Off Ver
    Excel 2007
    Posts
    20

    Using Combine macro to combine multiple worksheets - need to modify to paste formulas

    Good evening,

    I'm using the following code to combine multiple worksheets with the same layout into a combined worksheet within the same book (thanks to Jerry Beaucaire for the original code). I need to paste the formulas within the spreadsheet as well and think I just need to change the PasteAll to PasteFormulas and probably need to add PasteFormats as well, but as I am relatively new to all this, I'm not 100% sure how to do it. I tried a couple of combinations where the PasteAll function exists and still didn't get the desired result.

    Thanks in advance!

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor smuzoen's Avatar
    Join Date
    10-28-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    610

    Re: Using Combine macro to combine multiple worksheets - need to modify to paste formulas

    Leave the xlPasteAll as is - this part of the macro looks to be copying the titles to the Consolidate worksheet - you need to change the section with xlPasteValuesAndNumberFormats so it will copy formulas
    Please Login or Register  to view this content.
    Hope this helps.
    Anthony
    Pack my box with five dozen liquor jugs
    PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated

  3. #3
    Registered User
    Join Date
    05-18-2012
    Location
    North Carolilna
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Using Combine macro to combine multiple worksheets - need to modify to paste formulas

    Thank you!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1