Is it possible to create a sheets dynamically in button click?

[charles1981]

Hi,

I have designed one sheet with table to show data for one specific market.  now want to store the markets in one master table (around 20 markets) and want to create 20 sheets based on the original sheets designed for all markets (one sheet for each markets) when click the button.

is it possible please? any idea how to do that?

Thank you!

[martinpohl]

use Nprinting and page level

[charles1981]

sheet design common but data should be based on the specific market. when click the button it should create the 20 sheets with specific market data dynamically.