im using a macro that splits coulmn A and renames the worksheet to the names i listed below the problem is i have mutiply worksheets so this code just overwrite what i had from the previous sheet. I would like it to create another worksheet if the worksheet name exist already for exampl. i would like to do the following if NY worksheet exist to create and paste the new data in NY2 and so on for NJ.
Please Login or Register to view this content.
Last edited by daillest319; 01-24-2012 at 04:55 PM.
Where is the data available which needs to be copied?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
One way:
Please Login or Register to view this content.
Last edited by shg; 01-24-2012 at 03:25 PM.
Entia non sunt multiplicanda sine necessitate
Thanky you worked perfect
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks