I have a spreadsheet where if I type in search words in particular cells with defined names (model, region, series, epn), it will search through information in Sheet 2 and return the rows with the matching search words in Sheet 1 (like a search engine). However, I cannot edit the records in Sheet 1 as it is comprised of formulas. I have to go into Sheet 2 and then filter it according to the search words in Sheet 1. What I require is that if I click on a button in sheet 1, it will use the search words in the cells, and filter it accordingly in Sheet 2 and then take me to Sheet 2 to edit those records. I know it requires some level of VBA, but I am new to VBA and any help or guidance would be greatly appreciated.
Bookmarks