Macro to Copy Range to New Worksheet, and Name Worksheet after Range

[qwertyyy]

I need a macro to copy a range to a new worksheet and name the new worksheet by first doubleclicking on a cell in that range that i need copied.

[Logit]

.
The easiest method I can think of is to paste the following into the ThisWorkBook module :

Please Login or Register  to view this content.

Then, using the existing COPY command by RIGHT CLICKING the sheet and selecting COPY ...

First highlight the range you want to copy ... right click the selection and choose COPY.
Select the sheet you want to paste to ... right click and choose PASTE beginning in the first cell of the sheet where you want the data pasted.

Now, select the cell with the data that you want to use to name the Sheet Tab. Double Click the cell and the sheet name automatically changes.

[jaslake]

Hi qwertyyy

Are these Named Ranges you're referring to?

[qwertyyy]

Yes they are , I have a schedule of rates SOR with quite a lot of Sections and Pay items , Its way to hard to put all the quantity calculations on the one schedule of rates. So i usually copy each Section to a Sheet , do the calculations on that sheet and link it back to the Schedule of Rates Front Sheet. It Would be much easier if i could put all the sections on the SOR into named ranges then I could just double click on each pay Item Section Number and a macro could copy that Named Range its in to a new sheet and then rename the sheet after the number I clicked on.

[jaslake]

Hi qwertyyy

We can work with Named Ranges. It'll be helpful if I can see what you have and what you wish to do. Please attach a sample workbook the Structure of which is the same as your actual workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

INCLUDE ANY CODE YOU'RE USING OR HAVE TRIED.

Remember to desensitize the data.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.