Hello,
I have read numerous threads about creating a new worksheet, and having
the user enter the new name for the worksheet. I would like to know how
to target this new worksheet.


Example.
I would like to run a MACRO that copies data from a set worksheet,
creates a new worksheet and prompts the user for a name. Then I would
like to target this worksheet and paste the data.

The result would be that everytime this macro is run, a new mutually
exclusive worksheet is created, and named by a user. This can be done
over and over again, until there are multiple worksheets
Thanks,
-Brian


--
brianproctorla
------------------------------------------------------------------------
brianproctorla's Profile: http://www.excelforum.com/member.php...o&userid=27567
View this thread: http://www.excelforum.com/showthread...hreadid=470896