I have a price list with various headings in a column (C in this case). In between the headings are the various part numbers that the headings refer to. So I want to create a drop down list with all the headings in and be able to click on the required heading I want. The cursor will then go to that particular heading and if possible, that heading cell will be at the top of the screen with the part numbers below. I am sorry if this is a repeat question but I could not find a suitable answer in the forum. Many thanks in advance.
Bookmarks