4 Replies Latest reply on Oct 19, 2009 11:52 AM by spheon1969

    Creating new duplicate sheets

    spheon1969

      Hi - total noob here I am afraid

       

      I have created a surveying template with the first 3 pages generic to every survey/project and then the 4th that should be able to be duplicated as many times as required (ie one per room being surveyed)

       

      Is there anyway of adding a little macro or similar that if a button pressed a copy (blank) of sheet four will be created as sheet 5 and so on?

       

      edited....I have read elsewhere to use subforms and flowing - is there an idiots guide anywhere, I already have the page setup...and when I wrap the sheet with a subform and then flow it the formating goes everywhere and into 3 pages ...

       

      thanks in advance, I have attached the survey file if anyone can help it would be appreciated

       

      Sph