excel indexing using vba
Posted on 2012-09-11
I need to select a cell (or row) in second sheet based on a user selection in the first sheet. I would probably use the selection-changed event to triger the function. i.e. first sheet contains a list of section-headers that apply to sections in the second sheet.
Using hyperlinks and anchors isn't suitable because the user will be adding sections (and associated titles) frequently. Ideally I need a function that returns the row of the first occurence of the search string in the second sheet, so I can select that row in the second sheet.