Results 1 to 6 of 6

Macro to create multiple sheets from template and fill with datas from one sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-15-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2010
    Posts
    202

    Macro to create multiple sheets from template and fill with datas from one sheet

    Hello all,

    I have a file which is used to tabulate the results of a competition.
    I have a sheet(list) which has the datas like competition number(b4:b33), Driver(c4:c33), Co- Driver(d4:d33)
    and Category (e4:e33).
    In another sheet named (Template) which has the format of the sheet to be copied.

    In the list sheet if the comp no=1 driver = david co-driver = john and category = Expert
    then it should create a worksheet with name "1" competition number.

    The data must be copied to the respective cells.

    File attached for reference.
    Attached Files Attached Files

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