+ Reply to Thread
Results 1 to 1 of 1

Adding sublist on different worksheets

  1. #1
    Registered User
    Join Date
    05-09-2005
    Posts
    1

    Adding sublist on different worksheets

    I have a worksheet named masterlist with

    name company_name address sales sales_level headings

    The sales_level is either Silver Gold Platinum I want to create 3 more list on different worksheets one with silver level one with gold level and one with platinum level. I want all the headings to be on each list.

    So my worksheets would be

    Masterlist
    Silver
    Gold
    Platinum

    Silver
    Silver

    Gold
    Gold

    Platinum
    Platinum

    The tricky parts is I will be chaning the master list often and want the other list to automaticly update. I will also be adding new names and want the list to update automaticly. I have been trying to create the other list with vlookup but I am having trouble. The list is about 6000 compines.

    Any help would be greatly appricated.
    Last edited by Hunter; 05-09-2005 at 03:39 PM.

+ 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