Results 1 to 4 of 4

Sorting column into various worksheets by 'name'

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-11-2008
    Location
    uk
    MS-Off Ver
    365
    Posts
    424

    Sorting column into various worksheets by 'name'

    Hi All,

    I'm a bit stuck, so I hope that you guys can help me!

    I have a spreadsheet, which has a master worksheet that will contain the names of (<100) opponents placed in column b. To the right of these names are a number of events which each one could enter.

    I've then used a bit of code to register a tick along the corresponding rows if that particular opponent enters the corresponding 'event'.

    Now the problem is that I would like to automatically fill the corresponding column in the other worksheets (which correspond to each event...I'm going to start each one in cell b3 to ease matters), with all the names of the opponents who wish to enter each competition.

    I would then like to sort each of these generated columns in all worksheets alphabetically

    I attach a demo if I've not explained myself too clearly!!

    Hope you can help.
    Attached Files Attached Files
    Last edited by skyping; 03-18-2010 at 12:02 PM.

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