Setup new Sheet to operate independently from other sheets

[#1]

Hi all,

I have an application with 5 sheets/tabs, when a selection is made on one sheet this same selection will be applied across all the other sheets.  I want this to continue across these 5 sheets.  However I now have a requirement to create another tab but this tab should work independently from the other 5 sheets/tabs.  Therefore any selections (via list boxes) made on any of the 5 existing tabs should not impact this new tab .  So my question is how can I setup a new sheet that will operate as a standalone sheet?

Hopefully someone will know the answer!

Thank you

[MayilVahanan · Accepted solution]

Hi

Use alternate state in sheet properties.

Document proeprties ->General -alternates state

Hope it help

[#3]

Perfect, thanks Mayil...

[MayilVahanan]

Hi rebelman

Please close this post by mark as assumed answer or correct answer. So other don't want to open this post for solve it further

[kamakshisuram]

Thank you. It helped me

[#6]

Thanks. Helped me!