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.
Bookmarks