Results 1 to 3 of 3

Fill cells in different worksheets with data extracted form one particular worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    06-10-2013
    Location
    Quatre Bornes - Mauritius
    MS-Off Ver
    Excel 2010
    Posts
    10

    Fill cells in different worksheets with data extracted form one particular worksheet

    Dear Forum Members,

    I'm quite new to VBA Excel and i'm still struggling to find my way out.
    I have a workbook containing initially 2 worksheets namely 'Participants' and 'Planning'
    In the 'Participants' sheet I added a number of details about the participants and depending on the period that I will use the workbook i have to amend the 'Planning' worksheet according - Column A & B, all other columns remain the same.

    Following this I have to create a seperate 'Planning' worksheet for each participant and name the sheet with the participant's name.
    I managed to do all these using VBA (see attached).

    My issue now is that in each of the newly created worksheets, i need to replace the wording ' Branch 1' & 'Branch 2' with the corresponding branch name found in worksheet 'Participants' - column H & I

    It would be nice if the script could work with the button I placed in sheet 'Participant' - 'Create Worksheets'.
    This will avoid having multiple buttons in the worksheet

    Thanks you beforehand for your comments and feedback.

    Kind regards,

    Shaeto
    Attached Files Attached Files
    Last edited by shaeto; 06-11-2013 at 01:26 AM.

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