Sleeper: Urgent Help needed....
Hi all ,
Basicaly i have a spreadsheet with a summary sheet, a form template.... what im wanting to do is from the click of a button on the summary sheet copy the form from the template sheet tab (including formats) and paste after the last form e.g SCAF2 ....
so the new pasted form would then called SCAF3 and so on incrementing the name of the worksheet tab every time a copy of template is pasted ....... the summary sheet is already preset up to 100 Worksheets so that doesnt need configuring....
Example attached .... any help would be great!!!
Reply With Quote