+ Reply to Thread
Results 1 to 7 of 7

copy cells that contain..

  1. #1
    Registered User
    Join Date
    05-14-2008
    Posts
    7

    copy cells that contain..

    Hi everybody i'm new in the forum, and i need help for a very simple thing:

    i have a list in B:B of players and in C:C the respective teams; now what i want to do in another sheet is to paste the list of players of a specific team (this according on the team name written in A1) in this sheet.

    anybody can help me??

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    Hi,
    Check out this example
    http://www.excelforum.com/attachment...8&d=1201836478

  3. #3
    Registered User
    Join Date
    05-14-2008
    Posts
    7
    thank you very much! that's right what i was looking for!

    But i do not manage to make it work.. i already copied the vb code and edited it.. what else do i have to do?

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    Quote Originally Posted by teocomi
    thank you very much! that's right what i was looking for!

    But i do not manage to make it work.. i already copied the vb code and edited it.. what else do i have to do?
    I don't know,
    I can't see your workbook....

  5. #5
    Registered User
    Join Date
    05-14-2008
    Posts
    7
    Would it be a problem if i use excel 2007?

  6. #6
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    Quote Originally Posted by teocomi
    Would it be a problem if i use excel 2007?
    No problem, explain what you have edited? or what needs to be edited, did you get the code from the worksheet module?

  7. #7
    Registered User
    Join Date
    05-14-2008
    Posts
    7
    woah! i finally managed to do it! thank you anyway!

+ 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