Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying & Pasting into a newly created worksheet
Hi, Can anyone help with this?
I want to copy and paste values from one worksheet into another, but I want a new tab to be created each time. For example: I want the workbook to create a new tab, rename the tab according to a name or number in a certain cell from the main tab/Sheet and copy data from the main tab into it. Then when I run the macro again it would create another new tab and so on. I hope that makes sense. I can put together the copy and paste bit, its the how to create a new tab and name it according to values or text from a certain cell that I am having trouble with Help greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Refresh data from original worksheet to newly created copy | Excel Discussion (Misc queries) | |||
Can't find newly created userform | Excel Programming | |||
Referencing a newly created worksheet | Excel Worksheet Functions | |||
add list to newly created menu | Excel Worksheet Functions | |||
How do I return to newly created worksheet? | Excel Programming |