ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multiple Templates (https://www.excelbanter.com/excel-discussion-misc-queries/37689-multiple-templates.html)

pnurman

Multiple Templates
 

I have a few questions:

The first is:

Is it possible to have multiple templetes in one workbook (i.e. if
Sheet1 has the information such as Name: {myname} , Date: {today} , and
Information: {now} ) is it possible for corrosponding sheets after
sheet1 have the same information however, it omits "myname," "today"
and "now?" Instead read {yourname}, {tomorrow} and {later}? (or other
information?)

The second question corresponds with the first.

The second question is:

Is there a more effeciant way of adding multiple sheets? I have a
project I am working on that will require 50+ Sheets per book and
using the "copy or move" on the spreadsheets takes too long. I know
you can select multiple sheets and it adds x # sheets selected, however
I have the problem of going back and deleting the information. Is there
an easier way of doing this?

Thanks.

pnurman


--
pnurman
------------------------------------------------------------------------
pnurman's Profile: http://www.excelforum.com/member.php...o&userid=25706
View this thread: http://www.excelforum.com/showthread...hreadid=391237



All times are GMT +1. The time now is 08:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com