Hi Everyone,
This is probably an easy solve but i cant work it out so any help would be appreciated, I have attached the file to see exactly what I'm after -
Sheet 1 = QuoteForm
Sheet 2 = Table
Sheet 3 = Pivot Table
I have set up 4 columns on quoteform to be List's - List 1, List 2, List 3 and List 4. when I select an item in select List 1 I want List 2 to update and be dependable on 1 and then List 3 on 2 and List 4 on 3.
there will be many duplicates which will not be the whole row, my table will give you an idea of what i mean.
My dependable lists are currently referenced to the pivot tables due to the duplicates in the table.
Im currently stuck on how to make the lists dependable without creating named ranges for each separate item in my table, as this will be to time consuming and painful to add new items in.
I don't know my way around pivot tables that well and I cant seem to workout a formula for named ranges that will do the job i want.
thanks in advanced.
Bookmarks