+ Reply to Thread
Results 1 to 3 of 3

Macro to search the sheet name and copy and paste the data from a major sheet

  1. #1
    Registered User
    Join Date
    07-23-2009
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    9

    Macro to search the sheet name and copy and paste the data from a major sheet

    I have an excelworkbook which has n number of worksheetssheets in it.

    I have major sheet which has information pertainning to all the n sheets.
    Now what i want to do is copy the particualr information from the major sheet to the particular sheet.

    For Example i have ten different manager worksheets . The major sheet contains the data for all the managers.
    I want to copy the filename of each manager and search it in the major sheet and copy the information related to him to his sheet.

    Attached is the example.

    Please help me on this its very urgent.

    Thanks,
    Salma
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    762

    Re: Macro to search the sheet name and copy and paste the data from a major sheet

    Hi
    It is not clear from the attachment, which info you wish to copy from Major sheet to each manager's sheet
    Ravi

  3. #3
    Registered User
    Join Date
    07-23-2009
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Macro to search the sheet name and copy and paste the data from a major sheet

    Hi Ravi,

    I want to copy the information related to each manager from the major sheet say in the attachment i want to copy the the data from A2:c5 for the first manager similarly a6:c6 data to second manager sheet.
    I will have the horizontal rows to differentiate the data in major sheet.
    I hope the information is clear now.

    Thanks,
    Salma

+ 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