I have two bookmarks created and I have two report tabs.
I want to trigger bookmark A for Tab 1 and once I change to Tab 2 the bookmark should change to B.
You can add a Trigger through the sheet properties when you activate the sheet (OnActivateSheet). Just add Apply Bookmark witht the ID.
Retrieving data ...