I am working on a project which requires a way to enable all of the sheets within a suite (about 8 separate sheets within the workbook) to scroll to the same position.
All sheets are set up with a list of products going down the page and what I would like to do is to be able to scroll to a specific product on the active sheet and when I toggle to one of the other sheets they will have scroll to this same position as well.
I am thinking that I will need to use a look up funstion to search for the product name. Any suggestion would be extremely appreciated.
Thanks in advance.
Bookmarks