navigation between different selected values on a sheet
submit might confusing, sorry for that.
i have two sheets. sheet 1 have a client chart. when i select one select sheet 2 will open with all the related information for that specific client. this is currently implemented.
new requirement is: when user selects multiple clients (more than 1 client) on sheet 1 (ex: cl1, cl2, cl3), sheet 2 should open with navigation between selected client details. like page navigation from cl1, cl2, cl3. when i say navigation, my client selection should that particular client. if i navigated to cl2, client selection is cl2 and all objects on that sheet 2 should display related information.
is this a possible scenario ? unfortunately i can not provide any sample data.
