I am creating a template with the data that is copied into sheet1. The
user gets to choose which type of template they want and then it is
built using this macro. The ranges in both of the other sheets are
dynamic so I never know how big they are.
I would like to thank both JMB and Dick K. for the code snippets I will
use both of them.
--
TechWrangler
------------------------------------------------------------------------
TechWrangler's Profile:
http://www.excelforum.com/member.php...o&userid=34244
View this thread:
http://www.excelforum.com/showthread...hreadid=540004