Adding more Attacks with a Query

I'm modeling a Ship using a Broadside attack with all it's Cannons. But I want to be able to choose how many Cannons shoots at once. Is there a way to model a Macro, that a single decision increases the amounts of attacks (meaning seperate dice rolls) made. I want to be able to up to 10, and from that point on I can make more of those rolls, but doing them a bit at the time would become tedious with 34 Cannons to shoot.

Should be possible, are you using a particular sheet/system?

I'm using the standard Pathfinder character sheet and system in my games, and I'm interested in this answer as well as my players will be moving into the sea in a few weeks.