+ Reply to Thread
Results 1 to 4 of 4

Macro to create new sheets based on template no longer working

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Macro to create new sheets based on template no longer working

    Hi,

    I had the macro below which was working but now isn’t. The layout of the data has changed but I believe this should work:

    Please Login or Register  to view this content.
    The macro would copy the “Model” sheet to a new page each time and for each new sheet it would place the sheet reference in cell C4.

    So, as there are 5 customers on the “Data” sheet it would create 5 new sheets entitled “1”,”2”,”3”,”4”,”5” all containing the same information as on the “model” template.

    Can anyone see what is wrong?

    I have uploaded an example...
    Attached Files Attached Files
    Last edited by pauldaddyadams; 02-16-2012 at 03:51 PM.

  2. #2
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Macro to create new sheets based on template no longer working

    Hi
    It's looking for a custom Function SheetExists which is missing. Did you removed the code by mistake?

    buran
    If you are pleased with a member's answer then use the Star icon to rate it.

  3. #3
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Macro to create new sheets based on template no longer working

    As buran says you have somehow lost the function "SheetExists".

    Test the uploaded file and see if it now works as you expect.

    Alf

    PS Any credit for solving this should go to buran
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Re: Macro to create new sheets based on template no longer working

    Thanks Buran and Alf, it was the missing function that was causing this problem.

    Thank you both for solving it

+ 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