Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Listing Items (97 SR2)

    I have a rather large spreadsheet. The size usually varies, from 500 rows to 5000, depending on the compilation process I use.

    I'd like to devise a method of pulling alist from one column of data. There are only 12 items in the list, all twelve are repeated in defferent locations along the length of the column.

    Is there an easy way for me to pull a list of this twelve in such a way that each are lined up in a different sheet? For Example:

    Column A
    bob
    ted
    ted
    bob
    ted

    The process would populate two cells (because that's the number of individual criteria) in Sheet two to read:

    Column A
    bob
    ted

    Perhaps you all can go one step further to include the count on sheet two in column B?

    Thanks for all the help, I'm no stranger to VBA, but I can't seem to wrap my mind around this one. <img src=/S/bow.gif border=0 alt=bow width=15 height=15>
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Listing Items (97 SR2)

    Ahh well.. necessity is the mother of new processes! <img src=/S/headthrob.gif border=0 alt=headthrob width=15 height=15>

    I decided to use pivot tables, along with a refresh statement in the code. This seems to be working for now. Thanks all!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •